Hi,
I have a table in Postgres like:
CREATE TABLE test
(
id integer,
dtstamp timestamp without time zone,
rating real
)
CREATE INDEX test_all
ON test
USING btree
(id , dtstamp , rating);
My db has around 200M rows and I have reduced my test select statement down
to:
SELECT count(1) FR
On Wed, Feb 1, 2012 at 5:52 PM, Merlin Moncure wrote:
> On Wed, Feb 1, 2012 at 11:10 AM, Gudmundur Johannesson
> wrote:
> > Hi,
> >
> > I have a table in Postgres like:
> > CREATE TABLE test
> > (
> > id integer,
> > dtstamp timestamp witho
source for 9.2
since index-only-scan is "ready" according to
http://www.depesz.com/index.php/2011/10/08/waiting-for-9-2-index-only-scans/
?*
Thanks,
- Gummi
On Wed, Feb 1, 2012 at 7:35 PM, Merlin Moncure wrote:
> On Wed, Feb 1, 2012 at 12:50 PM, Gudmundur Johannesson
> wr
May be I should first try to partition the table by date and see if that
helps.
Thanks,
- Gummi
On Thu, Feb 2, 2012 at 8:30 PM, Merlin Moncure wrote:
> On Thu, Feb 2, 2012 at 10:41 AM, Gudmundur Johannesson
> wrote:
> > Do you think I should try using the latest build of the so
On Tue, Feb 7, 2012 at 3:11 PM, Igor Neyman wrote:
> From: Gudmundur Johannesson [mailto:gudmundur.johannes...@gmail.com]
> Sent: Thursday, February 02, 2012 11:42 AM
> To: Merlin Moncure
> Cc: pgsql-performance@postgresql.org
> Subject: Re: Index with all necessary columns - Po
