pgsql-performance@postgresql.org discussions for June 2003

22	Performance advice

I'd like to get some feedback on my setup to see if I can optimize my database performance. My application has two separate applications: The first application connects to websites and records the ...

Michael Mattox
Jun 24, 2003 at 7:39 am
Jun 26, 2003 at 12:50 pm

19	How to optimize monstrous query, sorts instead of using index

I've used indexes to speed up my queries but this query escapes me. I'm curious if someone can suggest an index or a way to modify the query to use the index. The query is: select ...

Michael Mattox
Jun 25, 2003 at 11:46 am
Jul 3, 2003 at 3:58 pm

12	FW: [ADMIN] Shared_buffers and kernel parameters, tuning

Howard Oblowitz
Jun 10, 2003 at 5:09 am
Jun 11, 2003 at 3:52 am

11	Memory question

Sorry for posting an obvious Linux question, but have any of you encountered this and how have you fixed it. I have 6gig Ram box. I've set my shmmax to 3072000000. The database starts up fine without ...

Patrick Hatcher
Jun 27, 2003 at 7:16 pm
Jun 30, 2003 at 4:02 pm

10	Postgres Connections Requiring Large Amounts of Memory

PostgreSQL Version: 7.2.3 OS : Red Hat 7.3 with Kernel 2.4.18-5 and SGI_XFS I currently have two processes which create several persistent connections to the database. One process primarily does ...

Dawn Hollingsworth
Jun 16, 2003 at 8:34 pm
Jun 18, 2003 at 7:10 am

10	Re-ordering .CONF params ... questions for this list

Folks, We've been discussing this for a while on HACKERS. However, I haven't been getting much feedback on the specific order proposed. Attached is an outline of my proposed re-ordering of ...

Josh Berkus
Jun 10, 2003 at 6:02 pm
Jun 16, 2003 at 4:31 pm

9	any way to use indexscan to get last X values with "order by Y limit X" clause?

Similar question was http://archives.postgresql.org/pgsql-admin/2002-05/msg00148.php, but google did not have answer for it. Here is the structure: Column | Type | Modifiers ...

Tomaz Borstnar
Jun 15, 2003 at 2:26 pm
Jun 16, 2003 at 7:23 am

8	problem with pg_statistics

Hi, i think i need a little help with a problem with pg_statistic. Lets say i have a table to collect traffic-data. The table has a column time_stamp of type timesamptz. The table has a single-column ...

Andre Schubert
Jun 26, 2003 at 1:15 pm
Jun 27, 2003 at 10:05 am

8	left join performance problem

Hi, I am using pg 7.3.1 on a dual r.h. 7.3 box. I have a big problem with pg left join performance. My plan is: =# explain analyze select D.IDS AS DIDS ,D.IDS_SKLAD, D.IDS_KO AS DIDSKO,KL.MNAME AS ...

Pginfo
Jun 11, 2003 at 4:43 pm
Jun 16, 2003 at 10:41 pm

8	7.3 vs 7.2 - different query plan, bad performance

Hi. I have a problem with performance after upgrading from 7.2 to 7.3. Let's see two simple tables: CREATE TABLE a ( id integer, parent_id integer ); with 1632 records, and CREATE TABLE b ( id ...

Ryszard Lach
Jun 13, 2003 at 6:45 pm
Jun 16, 2003 at 2:17 pm

6	Interesting incosistent query timing

Hi, I am researching some interesting inconsistent query timing and hope some of the gurus hanging out here might help me shed a light on this... The table: Column | Type | Modifiers ...

Ernest E Vogelsinger
Jun 16, 2003 at 10:47 pm
Jun 18, 2003 at 12:12 am

5	Recent 7.4 change slowed down a query by a factor of 3

The query below was running in a bit under 300ms on a version of 7.4 from less than a week ago until I updated to the version from last night. Now it takes about 800ms using a significantly different ...

Bruno Wolff III
Jun 18, 2003 at 2:59 pm
Jun 18, 2003 at 4:21 pm

5	Partial index where clause not filtering through

I have the following index: street_range__street_locality_high_low_v btree (street_name_id, locality_id, addr_high_v, addr_low_v) WHERE (addr_high_v IS NOT NULL) The query has a where clause like ...

Jim C. Nasby
Jun 16, 2003 at 5:31 am
Jun 16, 2003 at 10:39 pm

5	Enabling and disabling run time configuration parameters.

I have discovered that I could optimize queries by adjusting the following parameters such as enable_seqscan, enable_hashjoin, enable_mergejoin and enable_nestloop. Is it a good idea, to temporarily ...

Yusuf
Jun 5, 2003 at 3:35 pm
Jun 5, 2003 at 5:00 pm

4	Deleting one record from a table taking 17s.

Why would the following query take soo long to run? What does 28.12 msec represent, since the total running time is 16801.86 ms. The table phoneinfo has a primary key called phoneinfo_id and the ...

Yusuf
Jun 20, 2003 at 3:53 pm
Jun 20, 2003 at 10:04 pm

4	tweaking costs to favor nestloop

Hi, I'm running PG 7.3.2 on a dual P3 1 GHz, 4GB RAM, 5-disk RAID 5 (hardware) on Debian Linux, kernel 2.4.21-rc3. I'm unable to tweak the various _cost settings in such a way that attached query ...

Vincent van Leeuwen
Jun 11, 2003 at 7:33 pm
Jun 16, 2003 at 5:17 am

4	Hash or merge join instead of inner loop

I have a query that's cauing pgsql choose either a hash or merge join depending on how I mess with the stats variables, but it won't choose an nested loop, even though it's the fastest. The estimate ...

Jim C. Nasby
Jun 10, 2003 at 4:51 am
Jun 10, 2003 at 8:56 pm

4	Degrading performance

Hello, I have table with slowly degrading performance. Table is special is such way that all its rows are updated every 5 minutes (routers interfaces). vacuum does not help. vacuum full does but I'd ...

Mindaugas Riauba
Jun 2, 2003 at 5:33 am
Jun 2, 2003 at 6:00 pm

3	Large querie with several EXISTS which will be often runned

Hello, I've a performance question that I would like to ask you : I have to design a DB that will manage products, and I'm adding the product's options management. A box can be red or yellow, or with ...

Bruno BAGUETTE
Jun 27, 2003 at 2:31 pm
Jun 28, 2003 at 9:36 am

3	Similar querys, better execution time on worst execution plan

Hi all! I have a strange behavior with this query: SELECT c.id_contenido,p.fecha_publicacion,c.titulo_esp,c.activo,c.activo,s.label_esp as label_sbc,p.orden ...

Fernando Papa
Jun 25, 2003 at 7:26 pm
Jun 26, 2003 at 3:06 pm

3	sequential scans on few columns tables

Hi Recently I was wondering about tables difficult to index. Example - queries with "ilike" where clauses. Without additional contrib modules the only way to search such tables is sequential scan (am ...

Tomasz Myrta
Jun 16, 2003 at 7:49 pm
Jun 16, 2003 at 10:45 pm

2	Query planner plans very inefficient plans

I have a number of very common queries that the optimizer plans a very inefficient plan. I vacuum hourly. I'm wondering what I can do to make the queries faster. Here are the relevant tables: create ...

Robert Wille
Jun 30, 2003 at 6:00 pm
Jun 30, 2003 at 9:13 pm

2	'best practises' to speed up sorting? tuning postgresql.conf

I'm wondering how to speed up sorting which is slowing a query run regularly on a linux postgresql 7.3.3 system. The box is a dual PIII with 1Gb ram. The database is located on a 20Gb SCSI disk, with ...

Chris Hutchinson
Jun 28, 2003 at 11:32 am
Jun 28, 2003 at 11:58 am

2	Query running slower than same on Oracle

We are evaluating PostgreSQL for a typical data warehouse application. I have 3 tables below that are part of a Star schema design. The query listed below runs in 16 seconds on Oracle 9.2 and 3+ ...

Sailer, Denis (YBUSA-CDR)
Jun 25, 2003 at 9:33 pm
Jun 25, 2003 at 9:52 pm

2	FW: Query Plan problem

NOTICE: QUERY PLAN: Seq Scan on tbluser (cost=0.00..670.82 rows=221 width=3726)

George Papastamatopoulos
Jun 2, 2003 at 4:58 am
Jun 2, 2003 at 5:37 am

1	Limiting Postgres memory usage

Is there a way to limit the amount of memory that postgres will use?

Howard Oblowitz
Jun 17, 2003 at 10:00 am
Jun 17, 2003 at 10:26 am

1	functional indexes instead of regular index on field(s)?

Hello! How much does planner take into consideration index size? Can one help planner use indexes by having several functional indexes which should be smaller instead of one bigger index which covers ...

Tomaz Borstnar
Jun 16, 2003 at 5:39 pm
Jun 16, 2003 at 5:56 pm

1	Select Query Performance

Hi, I am running Postgresql 7.2.3 on a linux Qube with 256 RAM. I have a tabe with about 100,000 records. The table has a postgis geometry column. I have a GIST index on the table on the geometry ...

Ricky Prasla
Jun 2, 2003 at 1:13 am
Jun 2, 2003 at 1:49 am

0	Unsubscribe

Unsubscribe

Howard Oblowitz
Jun 23, 2003 at 6:46 am
Jun 23, 2003 at 6:46 am

0	approve xec5mm unsubscribe pgsql-performance jgimenez@sipec.es

approve xec5mm unsubscribe pgsql-performance jgimenez@sipec.es

Jordi Giménez
Jun 17, 2003 at 7:41 am
Jun 17, 2003 at 7:41 am

0	Adjusting fsm values was Re: [BUGS] db growing out of proportion

Hey Tom, Sorry for the long delay. I'd been having mail trouble, and your and postgresql mail servers were bouncing me because Starband (my ISP) doesn't setup a full DNS entry for their clients. I'm ...

Robert Creager
Jun 13, 2003 at 3:50 am
Jun 13, 2003 at 3:50 am

0	new monster box CONF suggestion please

Howdy folks. We just received an new monster box, and I would like to field suggestion on setting up the Conf file for the best performance **************BOX INFO*************** Compaq 2 x 2GHZ XEON ...

Patrick Hatcher
Jun 12, 2003 at 4:40 pm
Jun 12, 2003 at 4:40 pm

0	[Fwd: Re: Enabling and disabling run time configuration parameters.]

--------- THE QUERY ---------------- select sum(item.charge) as currentCharges , sum(item.gst) as gst , sum(item.pst) as pst , sum(item.hst) as hst , sum(item.qst) as qst , sum(item.federaltax) as ...

Yusuf
Jun 6, 2003 at 6:53 pm
Jun 6, 2003 at 6:53 pm

0	Re: Index speeds up one row table (why)?

sending thread to -performance from -bugs Sorry... Vacuum cannot be triggered -- nor would you want it to be. There really isn't anything wrong with vacuuming once every 5 seconds or so, as it'll ...

Rod Taylor
Jun 1, 2003 at 12:14 pm
Jun 1, 2003 at 12:14 pm

group	pgsql-performance @
categories	postgresql
discussions	34
posts	210
users	54
website	postgresql.org
irc	#postgresql

summaries	on	Hotkey: s
users list	on	Hotkey: d
user style	avatars	Hotkey: a

PostgreSQL > pgsql-performance > June 2003

Search Discussions

34 discussions - 210 posts

54 users for June 2003

Content

People

Support

Translate