pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mitch Vincent <mitch@doot.org>
To: PostGreSQL PHP Group <pgsql-php@postgresql.org>
Subject: Re: pg_pconnect - ??
Date: Mon, 28 Jan 2002 15:12:52 -0700
Message-ID: <017901c1a848$eec1bb30$0200000a@Mitch> (raw)
References: <Pine.SOL.3.96.1020128160529.25035E-100000@shell.gis.net>
	<p05101219b87b70bd3c70@[192.168.0.6]>

> The most traffic the user creates is when they change their rate
> table, they might add 20 to 50 rates at per week. I could run that
> stuff of an old 100 MHz Pentium with 16 MB RAM, if I had to and they
> would probably not see and performance issues. However, some of the
> bills they have process 500'000 line items at a time, this is where I
> need the horsepower - but at that stage, the connection is already
> made. The query runs across 4 tables and sometimes takes up to 4
> minutes.

If you post schema and queries then perhaps we could help you get that time
down a bit? Pardon the questions but you're indexing, VACUUM ANALYZE ' ing
and using EXPLAIN to see what your query plans are -- right?

I guess if we're going to open this can of worms we'd better take the
conversation to pg-general though...

Good luck!

-Mitch




view thread (26+ messages)  latest in thread

Message-ID: <017901c1a848$eec1bb30$0200000a@Mitch>
Permalink:  ../017901c1a848$eec1bb30$0200000a@Mitch/
Also on:    postgresql.org/message-id/017901c1a848$eec1bb30$0200000a@Mitch

 · 

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-php@postgresql.org
  Cc: mitch@doot.org
  Subject: Re: pg_pconnect - ??
  In-Reply-To: <017901c1a848$eec1bb30$0200000a@Mitch>
  References: <Pine.SOL.3.96.1020128160529.25035E-100000@shell.gis.net> <p05101219b87b70bd3c70@[192.168.0.6]> <017901c1a848$eec1bb30$0200000a@Mitch>

* 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