pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
To: pgsql-performance@postgresql.org
Subject: Re: any way to use indexscan to get last X values
Date: Mon, 16 Jun 2003 12:52:00 +0530
Message-ID: <3EEDBD70.15023.3CCA80F@localhost> (raw)
In-Reply-To: <5.2.1.1.0.20030616090124.02a85678@127.0.0.1>
References: <3EEDADF0.29611.3901BC1@localhost>

On 16 Jun 2003 at 9:08, Tomaz Borstnar wrote:
> So this really means major increase of performance for real situation - 
> forum with over 85 000 messages where you get rid of full scan and 2 full 
> sorts to display list of msgs which happens a lot. You can always use some 
> query/page caching things, but then people start to post duplicates, 
> because they think the message did not make it into the database.

OTOH, I was thinking of your original problem. If you could have two identical 
tables, one to store incoming posts and other to store approved posts, that 
should be lot more simpler.

Of course you need to vacuum much more if you are deleting from in queue but 
the kind of database you are handling, me need not tell you about vacuum..

Just a though..


Bye
 Shridhar

--
Drew's Law of Highway Biology:	The first bug to hit a clean windshield lands 
directly in front	of your eyes.




view thread (10+ messages)

Message-ID: <3EEDBD70.15023.3CCA80F@localhost>
Permalink:  ../3EEDBD70.15023.3CCA80F@localhost/
Also on:    postgresql.org/message-id/3EEDBD70.15023.3CCA80F@localhost

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: shridhar_daithankar@persistent.co.in
  Subject: Re: any way to use indexscan to get last X values
  In-Reply-To: <3EEDBD70.15023.3CCA80F@localhost>
  References: <3EEDADF0.29611.3901BC1@localhost> <3EEDBD70.15023.3CCA80F@localhost>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox