Quick Links

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

From:	Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To:	Douglas Alan <darkwater42(at)gmail(dot)com>
Cc:	Jeff Davis <pgsql(at)j-davis(dot)com>, pgsql-general(at)postgresql(dot)org
Subject:	Re: What is the right way to deal with a table with rows that are not in a random order?
Date:	2009-05-28 14:41:23
Message-ID:	dcc563d10905280741j45fb5721qc1b79e68af3b4f39@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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.

In response to

Re: What is the right way to deal with a table with rows that are not in a random order? at 2009-05-28 14:24:32 from Scott Marlowe

Responses

Re: What is the right way to deal with a table with rows that are not in a random order? at 2009-05-28 19:45:22 from Douglas Alan

Browse pgsql-general by date

	From	Date	Subject
Next Message	Tom Lane	2009-05-28 14:45:06	Re: Multidimensional array definition in composite type appears parsed as string
Previous Message	inf200468	2009-05-28 14:37:36	[Fwd: Re: a modo texto]