CODEWITHSUNDEEP
postgresqlindexingram
Richard
Richard

Reputation: 65600

Can I create a Postgres index that is bigger than RAM?

As the title says: is it possible to create, and use, a Postgres index that is larger, when created, than the value of RAM?

Clearly it's not ideal to do this, because even if it's possible it will be much faster if the index can be in RAM: but I'm interested in whether it's possible at all.

I am asking this question because I'd like a rough idea of the size of server I need for a particular project.

I've looked through the Postgres docs on creating an index, but I don't see the answer there. I suspect this is too basic a question even to be covered in the docs, and apologies if it's a stupid question :-(

Upvotes: 2

Views: 1840

Answers (1)

user_0
user_0

Reputation: 3363

Yes, you can. Ram is not a limit. Disk will be used to sort data and index building.

Upvotes: 2

Related Questions