FAQ

PostgreSQL > pgsql-performance > January 2004

Search Discussions

65 discussions - 350 posts

  • Hello All Just wanted to gather opinions on what file system has the best balance between performance and reliability when used on a quad processor machine running SuSE64. Thanks DAve
    Dave ThompsonDave Thompson
    Jan 23, 2004 at 4:44 pm
    Jan 31, 2004 at 6:40 pm
  • Speaking of special cases (well, I was on the admin list) there are two kinds that would really benefit from some attention. 1. The query "select max(foo) from bar" where the column foo has an index. ...
    John SiracusaJohn Siracusa
    Jan 5, 2004 at 7:03 pm
    Jan 6, 2004 at 11:20 pm
  • Hi, we are new to Postgres and we are evaluating Postgres 7.4 on MacOS X as an alternative to FrontBase 3.6.27. From the available features Postgres is the choice #1. We have some tests to check the ...
    David TeranDavid Teran
    Jan 5, 2004 at 11:29 am
    Jan 9, 2004 at 3:23 am
  • Hi, I am using pg 7.4.1 and have created a trigger over table with 3 M rows. If I start masive update on this table, pg executes this trigger on every row and dramaticaly slows the system. Exists in ...
    PginfoPginfo
    Jan 15, 2004 at 2:25 pm
    Jan 21, 2004 at 4:51 pm
  • Hi all, I've got a query that needs some help, please. Is there a way to avoid all the looping? I've got freedom to work with the double-indented sections below ) AND (, but the initial select ...
    Jack CoatesJack Coates
    Jan 29, 2004 at 1:06 am
    Jan 30, 2004 at 5:13 pm
  • I am writing a website that will probably have some traffic. Right now I wrap every .php page in pg_connect() and pg_close(). Then I read somewhere that Postgres only supports 100 simultaneous ...
    Jón RagnarssonJón Ragnarsson
    Jan 14, 2004 at 12:42 pm
    Jan 16, 2004 at 6:25 am
  • Our database has slowed right down. We are not getting any performance from our biggest table "forecastelement". The table has 93,218,671 records in it and climbing. The index is on 4 columns, ...
    Shea,Dan [CIS]Shea,Dan [CIS]
    Jan 22, 2004 at 7:47 pm
    Jan 23, 2004 at 12:21 am
  • I understand that COUNT queries are expensive. So I'm looking for advice on displaying paginated query results. I display my query results like this: Displaying 1 to 50 of 2905. 1-50 | 51-100 | ...
    David ShadovitzDavid Shadovitz
    Jan 11, 2004 at 6:11 pm
    Jan 19, 2004 at 11:59 pm
  • Hi, its me again. As far as we tested postgresql ist fast, very fast compared to the other db system we test and are using currently. We are now testing some test databases on Postgres. We use one ...
    David TeranDavid Teran
    Jan 30, 2004 at 6:00 pm
    Jan 31, 2004 at 9:12 pm
  • I have an application that I'm porting from MSSQL to PostgreSQL. Part of this application consists of hundreds of stored procedures that I need to convert to Postgres functions ... or views? At first ...
    Bill MoranBill Moran
    Jan 26, 2004 at 3:19 pm
    Jan 30, 2004 at 10:08 am
  • Hi all, Chris Browne (one of my colleagues here) has posted some tests in the past indicating that jfs may be the fastest filesystem for Postgres use on Linux. We have lately had a couple of cases ...
    Andrew SullivanAndrew Sullivan
    Jan 7, 2004 at 11:06 pm
    Jan 13, 2004 at 3:04 pm
  • Hi, We've set up a little test box (1GHz Athlon, 40G IDE drive, 256M RAM, Redhat 9) to do some basic comparisons between postgresql and firebird 1.0.3 and 1.5rc8. Mostly the results are comparable, ...
    Bradley TateBradley Tate
    Jan 8, 2004 at 5:53 am
    Jan 9, 2004 at 5:16 pm
  • I've been debating with a collegue who argues that indexing a boolean column is a BAD idea and that is will actually slow down queries. My plan is to have a table with many rows sharing 'versions' ...
    D. Dante LorensoD. Dante Lorenso
    Jan 4, 2004 at 1:19 am
    Jan 4, 2004 at 10:05 pm
  • Hi there. I've got a database (the schema is: http://compsoc.man.ac.uk/~cez/2004/01/14/tv-schema.sql) for television data. Now, one of the things I want to use this for is a now and next display. ...
    Ceri StoreyCeri Storey
    Jan 14, 2004 at 11:11 pm
    Jan 19, 2004 at 2:21 am
  • I have a very large table (about a million rows) which I most frequently want to select a subset of rows from base on a date field. That date field is indexed, and when Postgres uses that index, ...
    John SiracusaJohn Siracusa
    Jan 4, 2004 at 11:37 pm
    Jan 5, 2004 at 8:35 pm
  • Hi, I need to speed up the triggers that we are using and I began to make some tests to compare the "C" and pgSQL trigger performance. I try to write two identical test triggers (sorry I do not know ...
    PginfoPginfo
    Jan 22, 2004 at 10:47 am
    Jan 23, 2004 at 7:36 am
  • I have a situation that is giving me small fits, and would like to see if anyone can shed any light on it. I have a modest table (@1.4 million rows, and growing), that has a variety of queries run ...
    Andrew RawnsleyAndrew Rawnsley
    Jan 12, 2004 at 3:04 am
    Jan 12, 2004 at 3:01 pm
  • Hi, I have tried to tune a database that I'm using only for statistical access ... I mean that I'm importing a dump of my production database each night, but preserving some aggregat tables, and ...
    Hervé PiedvacheHervé Piedvache
    Jan 2, 2004 at 9:44 am
    Jan 3, 2004 at 2:54 am
  • I have a large query which I would like to place in a view. The explicit query is sufficiently fast, but the same query as a view is much slower and uses a different plan. I would appreciate an ...
    Reece HartReece Hart
    Jan 30, 2004 at 12:32 am
    Jan 30, 2004 at 7:27 pm
  • I'm trying to track down some performance issues where time (in milliseconds) is critical. One thing that I've noticed is that it seems like the first insert takes an inordinate amount of time. ...
    PC DrewPC Drew
    Jan 26, 2004 at 9:01 pm
    Jan 27, 2004 at 3:58 pm
  • Hi There, We are considering to use NetApp filer for a highly busy 24*7 postgres database and the reason we chose netapp, mostly being the "snapshot" functionality for backing up database online. The ...
    Shankar KShankar K
    Jan 12, 2004 at 9:46 pm
    Jan 23, 2004 at 3:01 pm
  • Gurus, I have defined the following values on a db: shared_buffers = 10240 # 10240 = 80MB max_connections = 100 sort_mem = 1024 # 1024KB is 1MB per operation effective_cache_size = 262144 # equals to ...
    Anjan DaveAnjan Dave
    Jan 15, 2004 at 11:52 pm
    Jan 16, 2004 at 5:24 pm
  • I've read most of the threads on insert speed in this list and wanted to share some interesting observations and a question. We've been benchmarking some dbs to implement Bayesian processing on an ...
    SydSyd
    Jan 15, 2004 at 1:57 pm
    Jan 16, 2004 at 2:29 am
  • I have reported this on the pgadmin-support mailing list, but Andreas Pflug has asked me to post it here. With a particular database, PgAdmin3 takes a very long time to connect to a database. this is ...
    Michael ShapiroMichael Shapiro
    Jan 6, 2004 at 8:50 pm
    Jan 6, 2004 at 11:13 pm
  • Hi I have a php script and i make a pg_pconnect If i want to make 4-10 pg_query in that script Have i to close the connection at end of the script? (i would say yes, is it right?) Sorry I m a little ...
    PostgresPostgres
    Jan 24, 2004 at 5:49 pm
    Apr 21, 2004 at 1:51 am
  • do views exist fysically a separate "table", or are they generated on the fly whenever they are queried? if they exist fysically they could improve performance (..php, web), for example a view being ...
    LoekeLoeke
    Jan 28, 2004 at 7:20 pm
    Feb 2, 2004 at 9:51 pm
  • Hi all , I'm trying to find out if there is a specific setting to make transactions time out faster in a scenario where there's an update on a table in a transaction block, and another update process ...
    StefStef
    Jan 28, 2004 at 4:33 pm
    Jan 28, 2004 at 5:38 pm
  • Please tell me if this timing makes sense to you for a Celeron 433 w/ RAM=256MB dedicated testing server. I expected some slowness, but not this high. db_epsilon=# \d t_active_subjects Table ...
    Octavio AlvarezOctavio Alvarez
    Jan 24, 2004 at 12:39 am
    Jan 25, 2004 at 2:13 am
  • Hi all, I'm quite newbie in SQL and I have a performance problem. I have the following table (with some extra fields) and without any index: CREATE TABLE STATISTICS ( STATISTIC_ID NUMERIC(10) NOT ...
    ArnauArnau
    Jan 21, 2004 at 6:50 pm
    Jan 21, 2004 at 8:59 pm
  • Folks, While debugging a wireless card, I came across this interesting bit: http://portal.suse.com/sdb/en/2003/10/pohletz_desktop_90.html What it indicates is that by default SuSE 9.0 plays with the ...
    Josh BerkusJosh Berkus
    Jan 16, 2004 at 8:38 pm
    Jan 17, 2004 at 1:51 am
  • Hi there, I am quite new to postgresql, and love the explain feature. It enables us to predict which SQL queries needs to be optimized before we see any problems. However, I've run into an issue ...
    Richard van den BergRichard van den Berg
    Jan 9, 2004 at 2:13 pm
    Jan 12, 2004 at 2:56 am
  • I have these two tables: Table "de.summary" Column | Type | Modifiers --------------+-----------------------------+--------------- isbn | character varying(10) | not null source | character ...
    Mike GloverMike Glover
    Jan 2, 2004 at 3:34 am
    Jan 2, 2004 at 10:29 pm
  • Hi, more strange plans ... Planner estimates an indexscan to return 240 rows although it is using a unique index and chooses to use hash join and seqscan instead of nested loop and indexscan. It's ...
    Kari LavikkaKari Lavikka
    Jan 30, 2004 at 9:15 am
    Jan 31, 2004 at 8:52 am
  • I have 2 columns index. The question is if optimizer can use both columns of an index or not, i.e. the plan should read like this: Index Cond: ((name)::text = 'name1'::text) AND ...
    LndLnd
    Jan 29, 2004 at 7:30 pm
    Jan 29, 2004 at 10:08 pm
  • Hi, with the following table: Table "public.foo" Column | Type | Modifiers --------+------+----------- t | text | Indexes: "a" btree (t) Shouldn't queries that use ... where t like '%something%' ...
    Marinos J. YannikosMarinos J. Yannikos
    Jan 27, 2004 at 7:30 pm
    Jan 27, 2004 at 10:47 pm
  • I've got a table with about 10 million events in it. Each has a user_id (about 1000 users) and a event_time timestamp covering a 4 year period with about 50% of the events being in the last year. ...
    Orion HenryOrion Henry
    Jan 23, 2004 at 6:59 pm
    Jan 26, 2004 at 8:53 pm
  • Hi all, First of all thanks to Josh and Richard for their replies. What I have done to test their indications is the following. I have created a new table identical to STATISTICS, and an index over ...
    ArnauArnau
    Jan 26, 2004 at 2:13 pm
    Jan 26, 2004 at 3:01 pm
  • I'm conducting some benchmarking (mostly for fun and learning), and one part of it is benchmarking PostgreSQL (7.4.1, on FreeBSD 4.9 and 5.2). I'm using pgbench from the contrib directory, but I'm ...
    Ivan VorasIvan Voras
    Jan 25, 2004 at 1:02 am
    Jan 25, 2004 at 12:23 pm
  • Here's the top item from the "top" listing on my Postgres machine: 10:20am up 98 days, 18:28, 3 users, load average: 1.14, 1.09, 0.85 103 processes: 101 sleeping, 1 running, 0 zombie, 1 stopped CPU0 ...
    John SiracusaJohn Siracusa
    Jan 17, 2004 at 3:35 pm
    Jan 17, 2004 at 9:35 pm
  • Any tips for speeding up index creation? I need to bulk load a large table with 100M rows and several indexes, some of which span two columns. By dropping all indexes prior to issuing the 'copy from' ...
    Eric JainEric Jain
    Jan 7, 2004 at 5:15 pm
    Jan 7, 2004 at 8:10 pm
  • I have just discovered that if one does a SELECT with a LIMIT and OFFSET values, say SELECT myfunc(mycol) FROM table LIMIT 50 OFFSET 10000 ; Then the whole of the selection expressions, including the ...
    Clive PageClive Page
    Jan 6, 2004 at 3:41 pm
    Jan 6, 2004 at 6:37 pm
  • I tried searching the archives to find something like this. The search function doesn't like me much, and believe me the feeling is mutual. So I'm forced to pollute your inboxes with yet another "why ...
    Chris TrawickChris Trawick
    Jan 3, 2004 at 5:38 am
    Jan 3, 2004 at 6:08 am
  • Hi, Postgres seems to estimate the cost of indexscan to be a bit too high. The table has something like 500000 rows and I have run reindex and vacuum analyze recently. Is there something to tune? ...
    Kari LavikkaKari Lavikka
    Jan 30, 2004 at 8:16 am
    Jan 30, 2004 at 3:07 pm
  • Anybody used Linux with EMC Clariions for PG databases? Any good war stories, pros, cons, performance results ? I'm wearing thin on my 6 disk 0+1 configuration and looking for something beefy, ...
    Cott LangCott Lang
    Jan 28, 2004 at 9:33 pm
    Jan 28, 2004 at 10:09 pm
  • Hello, With the new preload option is there any benefit/drawback to using pl/Python versus pl/pgSQL? And no... I don't care that pl/Python is now considered untrusted. Sincerely, Joshua D. Drake -- ...
    Joshua D. DrakeJoshua D. Drake
    Jan 27, 2004 at 6:51 pm
    Jan 28, 2004 at 1:00 am
  • Hi, Sorry for the long e-mail. Here is a summary of my questions: I am running osdl-dbt1 against pgsql-7.3.3. The result is at: http://khack.osdl.org/stp/286627/ 1. Based on the hardware and software ...
    Jenny ZhangJenny Zhang
    Jan 24, 2004 at 1:31 am
    Jan 25, 2004 at 9:14 pm
  • I need to get 200 sets of the most recent data from a table for further processing, ordered by payDate. My current solution is to use subselects to: 1 - get a list of unique data 2 - get the 200 most ...
    Ron St-PierreRon St-Pierre
    Jan 21, 2004 at 5:18 pm
    Jan 21, 2004 at 7:03 pm
  • Hi, I must have missed something, because I get really slow performance from PG 7.3.4-RH. This is my situation: I have a table (jms_messages), which contains 500.000 records. select count(*) from ...
    Jeroen BaekelandtJeroen Baekelandt
    Jan 21, 2004 at 9:34 am
    Jan 21, 2004 at 10:43 am
  • Hi, I searched through the archive and could not find any conclusive discussion of results on this. Has anyone compared the disk space usage between PostgreSQL and Oracle ? I am interested in knowing ...
    Seum-Lim GanSeum-Lim Gan
    Jan 9, 2004 at 4:19 am
    Jan 21, 2004 at 10:12 am
  • I'm running several postgreSQL databases containing tens of millions of rows. While postgreSQL has proven itself amazingly scalable, I am finding it difficult to properly tune/profile these databases ...
    Orion HenryOrion Henry
    Jan 20, 2004 at 8:16 pm
    Jan 21, 2004 at 1:45 am
Jan 2004
12
Group Navigation
period‹ prev | Jan 2004 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions65
posts350
users105
websitepostgresql.org
irc#postgresql

105 users for January 2004

Tom Lane: 50 posts Josh Berkus: 15 posts David Teran: 12 posts Stephan Szabo: 12 posts Richard Huxton: 11 posts Christopher Kings-Lynne: 10 posts Chris Browne: 9 posts Joshua D. Drake: 9 posts Greg Stark: 8 posts Dennis Björklund: 7 posts John Siracusa: 7 posts Bill Moran: 6 posts Jack Coates: 6 posts Scott.marlowe: 6 posts Shridhar Daithankar: 6 posts Hannu Krosing: 5 posts Mark Kirkwood: 5 posts Neil Conway: 5 posts Shea,Dan [CIS]: 5 posts Bruno Wolff III: 4 posts
show more
Archives