Search Discussions

50 discussions - 511 posts

  • We need to upgrade a postgres server. I'm not tied to these specific alternatives, but I'm curious to get feedback on their general qualities. SCSI dual xeon 5120, 8GB ECC 8*73GB SCSI 15k drives ...
    Apr 3, 2007 at 10:46 pm
    Apr 8, 2007 at 6:46 pm
  • Have you changed _anything_ from the defaults? The defaults are set so PG will run on as many installations as practical. They are not set for performance - that is specific to your equipment, your ...
    Steve CrawfordSteve Crawford
    Apr 26, 2007 at 7:49 pm
    May 6, 2007 at 7:07 am
  • Hello all, My website has been having issues with our new Linux/PostgreSQL server being somewhat slow. I have done tests using Apache Benchmark and for pages that do not connect to Postgres, the ...
    Jason LustigJason Lustig
    Apr 12, 2007 at 4:24 am
    Apr 17, 2007 at 4:44 am
  • Consider these two very similar schemas: Schema 1: CREATE TABLE foo ( id serial PRIMARY KEY, frobnitz character(varying 100) NOT NULL UNIQUE ); CREATE TABLE bar ( id serial PRIMARY KEY, foo_id int ...
    Kynn JonesKynn Jones
    Apr 14, 2007 at 11:19 am
    May 1, 2007 at 8:27 pm
  • I have 2 tables (A,B) joined in a many-to-many relationship via a join table ("membership"), where updating table A based on table B takes a very long time. Tables A and B have oid primary keys (a_id ...
    Drew WilsonDrew Wilson
    Apr 9, 2007 at 8:47 pm
    Apr 14, 2007 at 4:37 pm
  • Hi! I'm currently experimenting with PostgreSQL 8.2.4 and table partitioning in order to improve the performance of an application I'm working on. My application is about managing measurement values ...
    Andreas HaumerAndreas Haumer
    Apr 30, 2007 at 12:16 pm
    May 8, 2007 at 6:58 pm
  • Hi all, In MySQL when you create a table you can define something like: CREATE TABLE `sneakers` ( `sneaker_id` char(24) NOT NULL, `sneaker_time` int(10) unsigned NOT NULL default '0', `sneaker_user` ...
    Apr 3, 2007 at 6:59 pm
    Apr 18, 2007 at 8:03 pm
  • Hi, A page may be double buffered in PG's buffer pool and in OS's buffer cache. Other DBMS like DB2 and Oracle has provided Direct I/O option to eliminate double buffering. I noticed there were ...
    Xiaoning DingXiaoning Ding
    Apr 5, 2007 at 5:09 pm
    Apr 18, 2007 at 6:08 pm
  • Hi, I'm currently dealing with performance issues of postgres and looking for some advice. Platform Postgres: 7.0.2 OS: FreeBSD4.4 DB: size - about 50M, most frequently updated tables are of an ...
    Sergey TsukinovskySergey Tsukinovsky
    Apr 19, 2007 at 7:31 pm
    Apr 27, 2007 at 1:27 am
  • and here are the query plans referenced in my last email (apologies if you get these twice, they didn't seem to go through the first time, perhaps due to size?). I cut out the longer ones. Thanks, ...
    Alex DeucherAlex Deucher
    Apr 3, 2007 at 5:09 am
    Apr 5, 2007 at 3:35 pm
  • In investigating a slow query, I distiled the code below from a larger query: SELECT * FROM /* SUBQUERY banners */ ( SELECT * FROM /* SUBQUERY banners_links */ ( SELECT * FROM banners_links WHERE ...
    Henk de witHenk de wit
    Apr 21, 2007 at 11:24 pm
    Apr 28, 2007 at 10:51 pm
  • I have this table: CREATE TABLE test_zip_assoc ( id serial NOT NULL, f_id integer DEFAULT 0 NOT NULL, lat_radians numeric(6,5) DEFAULT 0.00000 NOT NULL, long_radians numeric(6,5) DEFAULT 0.00000 NOT ...
    Apr 24, 2007 at 9:27 pm
    Apr 27, 2007 at 4:49 am
  • I have performance problem with the following simple update query: UPDATE posts SET num_views = num_views + 1 WHERE post_id IN (2526,5254,2572,4671,25); The table "posts" is a large table with a ...
    Apr 14, 2007 at 1:50 pm
    Apr 21, 2007 at 4:18 pm
  • I have a query hitting a view that takes 0.15s on 8.1 but 6s on 8.2.3: select party_id from clan_members_v cm, clans c where cm.clan_id = c.id and c.type = 'standard' The problem seems to be that ...
    Jonathan EllisJonathan Ellis
    Apr 5, 2007 at 6:46 pm
    Apr 6, 2007 at 8:26 pm
  • Hello! I have strange situation. I`m testing performance of PostgreSQL database at different filesystems (ext2,ex3,jfs) and I cant say that JFS is as much faster as it is said. My test look`s like ...
    Paweł GruszczyńskiPaweł Gruszczyński
    Apr 25, 2007 at 7:16 am
    Apr 27, 2007 at 2:09 pm
  • I was recently running defrag on my windows/parallels VM and noticed a bunch of WAL files that defrag couldn't take care of, presumably because the database was running. What's disturbing to me is ...
    Jim NasbyJim Nasby
    Apr 26, 2007 at 7:51 am
    Apr 27, 2007 at 7:39 am
  • Hello All I sent this message to the admin list and it never got through so I am trying the performance list. We moved our application to a new machine last night. It is a Dell PowerEdge 6950 2X Dual ...
    John AllgoodJohn Allgood
    Apr 5, 2007 at 7:11 pm
    Apr 6, 2007 at 3:21 pm
  • Hi, we're using Postgres 8.1.4. We've been seeing deadlock errors of this form, sometimes as often as several times per hour: Apr 17 13:39:50 postgres[53643]: [4-1] ERROR: deadlock detected Apr 17 ...
    Steven FlattSteven Flatt
    Apr 18, 2007 at 3:07 pm
    Apr 19, 2007 at 2:29 pm
  • I have an odd performance issue on 8.2 that I'd thought I'd document here. I have a workaround, but I'm if there is something that I'm not seeing. ok, for starters: I have a large table that is ...
    Merlin MoncureMerlin Moncure
    Apr 9, 2007 at 7:23 pm
    Apr 10, 2007 at 6:21 pm
  • Hi, I have pg 8.1.4 running in Windows XP Pro wirh a Pentium D and I notice that I can not use more than 50% of the cpus (Pentium D has 2 cpus), how can I change the settings to use the 100% of it. ...
    Andres RetzlaffAndres Retzlaff
    Apr 27, 2007 at 4:43 am
    Apr 28, 2007 at 7:28 pm
  • Hi, I'm using RHEL4 and wondering if I need to upgrade the php and php-pgsql packages when upgrading from Postgres 7.4.1 to 8.2.3. Any Help? Thanks Mike
    Michael DenglerMichael Dengler
    Apr 10, 2007 at 7:44 pm
    Apr 11, 2007 at 9:47 pm
  • We have a table which we want to normalize and use the same SQL to perform selects using a view. The old table had 3 columns in it's index (region_id,wx_element,valid_time). The new table ...
    Dan SheaDan Shea
    Apr 24, 2007 at 3:17 pm
    Apr 24, 2007 at 9:13 pm
  • Hello everyone, This is my first post in here, i am in need of some help... Wel, i am running PostgreSQL 8.2.4, in a single node, in this machine: Dell PowerEdge 1950 Intel Xeon 2.33 (2 CPUs) 4GB RAM ...
    Nelson KotowskiNelson Kotowski
    Apr 21, 2007 at 2:54 pm
    Apr 24, 2007 at 8:53 am
  • Hi, I am trying to figure out how to debug a performance problem / use psql explain. The table in question is: # \d word_association; Table "public.word_association" Column | Type | Modifiers ...
    S dS d
    Apr 9, 2007 at 9:09 am
    Apr 12, 2007 at 4:16 am
  • We have a query which generates a small set of rows (~1,000) which are to be used in a DELETE on the same table. The problem we have is that we need to join on 5 different columns and it takes far ...
    Spiegelberg, GregSpiegelberg, Greg
    Apr 9, 2007 at 8:02 pm
    Apr 10, 2007 at 4:46 pm
  • One more anomaly between 7.4 and 8.2. DB dumped from 7.4 and loaded onto 8.2, both have locale set to C. 8.2 seems to prefer Seq Scans for the first query while the ordering in the second query seems ...
    Alex DeucherAlex Deucher
    Apr 6, 2007 at 8:38 pm
    Apr 9, 2007 at 8:37 pm
  • Hello, I am trying to build a application to search CDs and their tracks and I am experiencing some performance difficulties. The database is very simple at the moment, two tables "cd" and "tracks" ...
    Tilo BuschmannTilo Buschmann
    Apr 7, 2007 at 11:12 am
    Apr 7, 2007 at 5:27 pm
  • Hi! I read the link below and am puzzled by or curious about something. http://www.postgresql.org/docs/8.1/interactive/datatype-character.html The Tip below is intriguing "Tip: There are no ...
    Siddharth AnandSiddharth Anand
    Apr 27, 2007 at 3:56 pm
    Apr 27, 2007 at 5:12 pm
  • Hi all, I'm a bit new to PostgreSQL and database design in general so forgive me for asking stupid questions. ;-) I've setup a PostgreSQL database on a Linux machine (2 processor, 1GB mem) and while ...
    Jeroen KleijerJeroen Kleijer
    Apr 21, 2007 at 8:46 pm
    Apr 26, 2007 at 7:22 pm
  • Hello All, I've been searching the archives for something similar, without success.. We have an application subjected do sign documents and store them somewhere. The files size may vary from Kb to ...
    Alexandre VasconcelosAlexandre Vasconcelos
    Apr 4, 2007 at 2:04 pm
    Apr 22, 2007 at 9:06 am
  • I have two tables, staff (530 rows) and location (2.5 million rows). I do a query that joins the two together, as so: SELECT s.ProprietorId, l.LocationId, s.RoleId FROM Location l INNER JOIN ( SELECT ...
    Colin McGuiganColin McGuigan
    Apr 21, 2007 at 5:50 am
    Apr 22, 2007 at 2:45 am
  • Hello All. I have a lot of tables and indexes in database. I must to determine which indexes are not using or using seldon in databese . I enabled all posible statistics in config but a can`t ...
    Denis LishtovnyDenis Lishtovny
    Apr 2, 2007 at 8:17 am
    Apr 2, 2007 at 2:42 pm
  • Dear, We are facing performance tuning problem while using PostgreSQL Database over the network on a linux OS. Our Database consists of more than 500 tables with an average of 10K records per table ...
    Shohab AbdullahShohab Abdullah
    Apr 26, 2007 at 11:44 am
    Apr 26, 2007 at 5:03 pm
  • I have a table that contains a column for keywords that I expect to become quite large and will be used for web searches. I will either index the column or come up with a simple hashing algorithm add ...
    Apr 20, 2007 at 2:24 pm
    Apr 26, 2007 at 8:35 am
  • Hi Is there a way to get the cache hit ratio in PostGreSQL ? Cheers -- -- Jean Arnaud -- Projet SARDES -- INRIA Rhône-Alpes / LSR-IMAG -- http://sardes.inrialpes.fr/~jarnaud
    Jean ArnaudJean Arnaud
    Apr 3, 2007 at 2:26 pm
    Apr 3, 2007 at 6:03 pm
  • Hi, We're facing some perfomance problems with the database for a web site with very specific needs. First of all, we're using version 8.1 in a server with 1GB of RAM. I know memory normally should ...
    Mauro N. InfantinoMauro N. Infantino
    Apr 27, 2007 at 5:45 pm
    Apr 28, 2007 at 8:43 pm
  • Hi, Is there a query I can perform (perhaps on a system table) to return all of the column names (ONLY the column names) for a given DB? (I seem to remember doing this before but cant remember how) ...
    Michael DenglerMichael Dengler
    Apr 19, 2007 at 5:06 pm
    Apr 19, 2007 at 7:26 pm
  • Is there a pg_stat_* table or the like that will show how bloated an index is? I am trying to squeeze some disk space and want to track down where the worst offenders are before performing a global ...
    Dan HarrisDan Harris
    Apr 13, 2007 at 8:01 pm
    Apr 14, 2007 at 8:31 am
  • And by the subject, I mean: please provide a "factual" answer, as opposed to the more or less obvious answer which would be "no one in their sane mind would even consider doing such thing" :-) 1) ...
    Carlos MorenoCarlos Moreno
    Apr 9, 2007 at 8:05 pm
    Apr 13, 2007 at 8:39 pm
  • We are trying to attack this problem from multiple avenues, thus I'm starting a separate thread. This is with regard to the problem posted via thread: ...
    Apr 6, 2007 at 3:41 pm
    Apr 6, 2007 at 5:05 pm
  • Hello group, I need to design and develop a web reporting system to let users query/view syslog files on a unix host. For now, I am concentrating on the authentication file that has user logon ...
    Fei LiuFei Liu
    Apr 30, 2007 at 2:13 pm
    May 1, 2007 at 5:36 pm
  • Hi! I read the link below and am puzzled by or curious about something. http://www.postgresql.org/docs/8.1/interactive/datatype-character.html The Tip below is intriguing "Tip: There are no ...
    Siddharth AnandSiddharth Anand
    Apr 27, 2007 at 3:56 pm
    Apr 27, 2007 at 4:35 pm
  • Hi, I tried to create a standby system as per the steps mentioned in the following article http://archives.postgresql.org/sydpug/2006-10/msg00001.php. Can anybody let me know the steps which are ...
    Nimesh SatamNimesh Satam
    Apr 24, 2007 at 7:12 am
    Apr 24, 2007 at 9:33 am
  • Hi, I have a table in my database that is updated every minute with new acquired data. Anyway there is a query to get latest values to be displayed on screen. I have postgresql 7.4.2 that work very ...
    Arkadiusz RajArkadiusz Raj
    Apr 23, 2007 at 5:46 pm
    Apr 23, 2007 at 6:19 pm
  • I have a table where I store email, the bodies are mostly kept in a toast table. The toast table is 940 Meg in size. The whole database is about 1.2 Gig in size. When I back the database up using ...
    David HinkleDavid Hinkle
    Apr 17, 2007 at 9:30 pm
    Apr 23, 2007 at 8:46 am
  • We had problems again, caused by long running transactions. I'm monitoring the pg_stat_activity view, checking the query_start of all requests that are not idle - but this one slipped under the radar ...
    Tobias BroxTobias Brox
    Apr 10, 2007 at 10:50 pm
    Apr 18, 2007 at 6:26 pm
  • Dear All. How to compute the frequency of predicate (e.g. Salary $70000) in an SQL query from a DB's pre-defined indexes?". I'm specifically looking at how to retrieve information about indices (like ...
    Avdhoot Kishore SapleAvdhoot Kishore Saple
    Apr 13, 2007 at 8:59 am
    Apr 13, 2007 at 2:17 pm
  • Hi, Ive looked through the README in the contrib/adminpack dir but it doesn't really say what these functions do and how to use them.... Any help? Thanks miguel
    Michael DenglerMichael Dengler
    Apr 5, 2007 at 6:02 pm
    Apr 5, 2007 at 6:06 pm
  • A better solution, and one I've used for years, is to use OS- or database-specific features, but carefully encapsulate them in a single module, for example, "database_specific.java". For example, ...
    Craig A. JamesCraig A. James
    Apr 3, 2007 at 9:40 pm
    Apr 3, 2007 at 9:40 pm
  • Sorry if anyone receives this twice; it didn't seem to go through the first time. I'll attach the query plans to another email in case they were causing a size limit problem. Also here's the here's ...
    Alex DeucherAlex Deucher
    Apr 2, 2007 at 2:51 pm
    Apr 2, 2007 at 2:51 pm
Group Navigation
period‹ prev | Apr 2007 | next ›
Group Overview
grouppgsql-performance @

140 users for April 2007

Tom Lane: 66 posts Alex Deucher: 19 posts Ron: 18 posts Steve: 17 posts David: 15 posts Merlin Moncure: 15 posts Scott Marlowe: 12 posts Greg Smith: 11 posts Carlos Moreno: 9 posts Craig A. James: 8 posts Henk de wit: 8 posts Michael Stone: 8 posts Andreas Kostyrka: 7 posts Arjen van der Meijden: 7 posts Erik Jones: 7 posts Joshua D. Drake: 7 posts Dave Cramer: 6 posts Jason: 6 posts Jeff Frost: 6 posts Jonathan Ellis: 6 posts
show more