Hi folks.
I have a view used_diary_details shown below.
If I do a basic search on one of the fields of the underlying table the select
takes under 1/2 second.
If I do a search using the derived field it takes over 15 seconds.
Anyone know how I can improve this as it's killing my app.
-- Takes
On Tue, Aug 30, 2005 at 03:38:52PM +0700, Ricky Sutanto wrote:
> I use Apache Web Server and PostgreSQL 7.3 to collect data everyday. Now it
> has been 5 month since I install that server.
>
> I wonder why now my web very slow to retrieve and display data?
> When I check the memory, I found that
I use Apache Web Server and PostgreSQL 7.3 to collect data everyday. Now it
has been 5 month since I install that server.
I wonder why now my web very slow to retrieve and display data?
When I check the memory, I found that postgreSQL client seem not release
after allocate. I try to find bug on
On Tue, Aug 30, 2005 at 15:42:06 +0700,
Ricky Sutanto <[EMAIL PROTECTED]> wrote:
>
> I use Apache Web Server and PostgreSQL 7.3 to collect data everyday. Now it
> has been 5 month since I install that server.
>
> I wonder why now my web very slow to retrieve and display data?
> When I check t
On Tue, Aug 30, 2005 at 03:42:06PM +0700, Ricky Sutanto wrote:
> I use Apache Web Server and PostgreSQL 7.3 to collect data everyday. Now it
> has been 5 month since I install that server.
Which release of PostgreSQL 7.3? What operating system and version?
> I wonder why now my web very slow to
I use Apache Web Server and PostgreSQL 7.3 to collect data everyday. Now it
has been 5 month since I install that server.
I wonder why now my web very slow to retrieve and display data?
When I check the memory, I found that postgreSQL client seem not release
after allocate. I try to find bug on
"Michael L. Hostbaek" <[EMAIL PROTECTED]> writes:
> I cron script is being run every night (while very low db activity),
> that deletes all rows from the table, and injects a bunch of new data...
You should vacuum in between ... or even better, do the deletion with
TRUNCATE.
On 27/04/2004 10:12 Michael L. Hostbaek wrote:
[snip]
Is this normal ? If I run the same select on another table in the same
database with ~40.000 rows, it takes approx 820.00ms...
You would probably get better answers on the correct list but my guess is
that your fsm setting might be too low for
Howdy,
I am expiriencing some performance issues, on a table in my postgres db.
I cron script is being run every night (while very low db activity),
that deletes all rows from the table, and injects a bunch of new data...
Every day between 60.000 and 100.000 rows.
Info:
ppdb=> select version();
Achilleus,
> > > The pgsql db is indexed on the
> > > 'authuser' field, and I've run 'analyze logfile'.
> >
> > He also needs to index the bytes field and the traffic field. And run
> ^^^
>
> Index on an aggregate function???
>
> I thoug
Ryan Littrell wrote:
>
> I am trying to execute the following command:
>
> SELECT R.*, distance(L1.lat, L1.lon, L2.lat, L2.lon) AS Distance
> FROM Restaurants R, Locations L1, Locations L2, FoodTypeRestaurantIDX FTR
> WHERE R.Zipcode=L1.Zipcode AND L2.Zipcode = '93705' AND R.Delivery=true AND
>
I am trying to execute the following command:
SELECT R.*, distance(L1.lat, L1.lon, L2.lat, L2.lon) AS Distance
FROM Restaurants R, Locations L1, Locations L2, FoodTypeRestaurantIDX FTR
WHERE R.Zipcode=L1.Zipcode AND L2.Zipcode = '93705' AND R.Delivery=true AND
R.RestaurantID=FTR.RestaurantID AND
12 matches
Mail list logo
