Postgres Pro
Downloads
Home   >   mailing lists

Re: What is the right way to deal with a table with rows that are not in a random order? - Mailing list pgsql-general

From Scott Marlowe
Subject Re: What is the right way to deal with a table with rows that are not in a random order?
Date
Msg-id dcc563d10905280741j45fb5721qc1b79e68af3b4f39@mail.gmail.com
Whole thread Raw
In response to Re: What is the right way to deal with a table with rows that are not in a random order?  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: What is the right way to deal with a table with rows that are not in a random order?  (Douglas Alan <darkwater42@gmail.com>)
List pgsql-general
Tree view 
Note that in the OPs case I'd probably try testing things like turning
off seqscan, or lowering random_page_cost.  I'd also look at
clustering on the index for the field you're selecting on.

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: What is the right way to deal with a table with rows that are not in a random order?
Next
From: inf200468@ucf.edu.cu
Date:
Subject: [Fwd: Re: a modo texto]