UNSUBSCRIBE ME PLEASE!

From: Evan Macosko <macosko(at)fas(dot)harvard(dot)edu>
To: Eric Cholet <cholet(at)logilune(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: UNSUBSCRIBE ME PLEASE!
Date: 2003-01-29 16:46:26
Message-ID: Pine.OSF.4.44.0301291145020.7630-100000@is01.fas.harvard.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

To whomever runs this list:

I have tried repeatedly to get majordomo to unsubscribe me from this list,
to no avail. I do not currently have the means of filtering my inbox at
this address, so receiving these emails is EXTREMELY annoying for me.
PLEASE PLEASE PLEASE PLEASE unsubscribe me. PLEASE.

On Wed, 29 Jan 2003, Eric Cholet wrote:

> I have this schema:
>
>
> motid | integer | not null
> objid | integer | not null
> date | timestamp without time zone | not null
> Indexes: dico_frs_motid_date btree (motid, date)
> dico_frs_objid btree (objid)
>
> The performance I'm getting from the index that contains
> 'date' is much slower than when using the objid index
> (different queries of course). This is a 10 million row
> table. Am I right to assume that postgres needs to do
> more work because it has to convert the dates to some
> internal (integer?) format?
> Consequently would I gain performance if I changed the
> schema so that 'date' is an integer (which would not
> be a problem for my application) ?
>
> Thanks,
> --
> Eric Cholet
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-01-29 16:49:19 Re: monitoring postgres
Previous Message Eric Cholet 2003-01-29 16:37:15 index on timestamp performance