Search Discussions

44 discussions - 447 posts

  • Hello, I'm about to buy SSD drive(s) for a database. For decision making, I used this tech report: http://techreport.com/articles.x/16255/9 http://techreport.com/articles.x/16255/10 Here are my ...
    Laszlo NagyLaszlo Nagy
    Nov 13, 2009 at 12:46 pm
    Mar 3, 2010 at 3:16 pm
  • We're about to purchase a new server to store some of our old databases, and I was wondering if someone could advise me on a RAID card. We want to make a 6-drive SATA RAID array out of 2TB drives, ...
    Matthew WakelingMatthew Wakeling
    Nov 24, 2009 at 5:23 pm
    Dec 7, 2009 at 11:14 pm
  • I've got a pair of servers running PostgreSQL 8.0.4 on Windows. We have several tables that add and delete massive amounts of data in a single day and are increasingly having a problem with drive ...
    Nov 16, 2009 at 5:47 pm
    Nov 17, 2009 at 5:10 pm
  • Dear All, I've just joined this list, so let me first thank you in advance for your hospitality. I'm having lots of trouble with variously slow running queries on a production system. I've tried all ...
    Richard NeillRichard Neill
    Nov 20, 2009 at 5:38 am
    Nov 22, 2009 at 3:14 pm
  • Hi ! We recently had a problem with wal archiving badly impacting the performance of our postgresql master. And i discovered "cstream", that can limite the bandwidth of pipe stream. Here is our new ...
    Laurent LabordeLaurent Laborde
    Nov 10, 2009 at 11:56 am
    Nov 16, 2009 at 9:26 am
  • Dear All, I'm wondering whether Vacuum/analyse (notably by the autovaccuum daemon) is responsible for some deadlocks/dropouts I'm seeing. One particular table gets hit about 5 times a second (for ...
    Richard NeillRichard Neill
    Nov 26, 2009 at 4:20 pm
    Dec 9, 2009 at 2:13 am
  • Dear All, Thanks for your help earlier with the previous question. I wonder if I might ask another. We have various queries that need to run, of which I'm going to focus on 2, "vox" and "du_report". ...
    Richard NeillRichard Neill
    Nov 22, 2009 at 3:31 pm
    Dec 3, 2009 at 3:16 am
  • Hi All, Running Pg 8.3RC2, Linux server, w/8GB RAM, OpenSuSE 10.2 OS (yes, I know that's old). I have seen *really* long-running autovacs eating up system resources. While the below is not an example ...
    Wayne BeaverWayne Beaver
    Nov 12, 2009 at 2:33 pm
    Nov 16, 2009 at 5:02 pm
  • Hi all, I'm experiencing a strange behavior with my postgresql 8.3: performance is degrading after 3/4 days of running time but if I just restart it performance returns back to it's normal value.. In ...
    Lorenzo AllegrucciLorenzo Allegrucci
    Nov 20, 2009 at 9:52 am
    Nov 25, 2009 at 11:07 am
  • Hi, everyone. Between postres docs, forum posts, previous similar questions answered and random blogs, I've read as much as I could about why others have had similar problems in the past before ...
    Eddy Escardo-RaffoEddy Escardo-Raffo
    Nov 15, 2009 at 10:51 pm
    Nov 16, 2009 at 10:15 pm
  • I'm facing a problem where running a CREATE TABLE has slowed down significantly over time. This is problematic because my application needs to routinely create a new schema and create 300 tables in ...
    Aris Samad-YahayaAris Samad-Yahaya
    Nov 8, 2009 at 3:22 am
    Nov 9, 2009 at 5:04 pm
  • Hi everybody, I've got two queries that needs optimizing. Actually, there are others, but these are pretty representative. You can see the queries and the corresponding plans at ...
    Faheem MithaFaheem Mitha
    Nov 23, 2009 at 10:47 pm
    Nov 30, 2009 at 3:41 pm
  • Hi: I have an application wherein a process needs to read data from a stream and store the records for further analysis and reporting. The data in the stream is in the form of variable length records ...
    Jay ManniJay Manni
    Nov 4, 2009 at 3:08 am
    Nov 5, 2009 at 8:06 am
  • Hello, I've run in a severe performance problem with the following statement: DELETE FROM t1 WHERE t1.annotation_id IN ( SELECT t2.annotation_id FROM t2) t1 contains about 48M record (table size is ...
    Luca TettamantiLuca Tettamanti
    Nov 24, 2009 at 1:39 pm
    Nov 25, 2009 at 4:16 pm
  • Hello All -- I have a simple queuing application written on top of postgres which I'm trying to squeeze some more performance out of. The setup is relatively simple: there is a central queue table in ...
    Brian KarlakBrian Karlak
    Nov 3, 2009 at 8:30 pm
    Nov 9, 2009 at 2:35 pm
  • Hi all, I have now readed many many forums and tried many different solutions and I am not getting good performance to database. My server is Debian linux, with 4gb ram, there is also java ...
    Nov 2, 2009 at 1:58 pm
    Nov 6, 2009 at 3:45 pm
  • Hello I just finished implementing a "search engine" for my site and found ts_headline extremely slow when used with a Polish tsearch configuration, while fast with English. All of it boils down to a ...
    Wojciech KnapikWojciech Knapik
    Nov 14, 2009 at 11:33 am
    Nov 15, 2009 at 2:06 pm
  • Hi, I have several long text fields in my DB that I would love to compress (descriptions, URLs etc). Can you tell me what options exists in PG (+pointers please), typical effect on space and run ...
    Shaul DarShaul Dar
    Nov 1, 2009 at 2:52 pm
    Nov 2, 2009 at 10:24 am
  • Hi everybody, I have an java application like this: while ( true ) { Thread.sleep( 1000 ) // sleeps 1 second SELECT field1 FROM TABLE1 WHERE field2 = '10' if ( field1 != null ) { BEGIN; ...
    Nov 30, 2009 at 5:02 pm
    Dec 1, 2009 at 3:49 pm
  • Hi, I am trying to run postgresql functions with threads by using OpenMP. I tried to parallelize slot_deform_tuple function(src/backend/access/ common/heaptuple.c) and added below lines to the code. ...
    Reydan CankurReydan Cankur
    Nov 28, 2009 at 12:10 pm
    Nov 29, 2009 at 3:34 pm
  • Thanks folks for the quick replies. 1. There is one transaction, connected from the JVM, that is showing "IDLE in transaction" .... this appears to be a leftover from Hibernate looking at the schema ...
    Dave CrookeDave Crooke
    Nov 4, 2009 at 11:52 pm
    Nov 6, 2009 at 8:22 am
  • Hi Developers and Tuners, Is there any way to run some query in low priority and some query in higher priority in pg. The main reason for this is i need my main application(high priority) to be ...
    S ArvindS Arvind
    Nov 5, 2009 at 9:37 am
    Nov 5, 2009 at 6:02 pm
  • Imagine a large table with a GIN index on a tsvector. The user wants a particular document, and is sure four words are in it. One of them only appears in 100 documents. The other three each appear in ...
    Kevin GrittnerKevin Grittner
    Nov 2, 2009 at 10:06 pm
    Nov 3, 2009 at 9:51 pm
  • Dear All. Can any one give me dynamic sql in postgres stored procedure using "USING CLAUSE" Regards, Ram
    Nov 24, 2009 at 11:25 am
    Jan 25, 2010 at 12:24 pm
  • Are the FSM parameters for each database, or the entire Postgres system? In other words, if I have 100 databases, do I need to increase max_fsm_pages and max_fsm_relations by a factor of 100, or keep ...
    Craig JamesCraig James
    Nov 19, 2009 at 6:19 pm
    Dec 24, 2009 at 10:24 am
  • Hello, I've inherited some very...interestingly... designed tables, and am trying to figure out how to make them usable. I've got an ugly hack in place, but it will not use an index properly, and I'm ...
    Jonathan FoyJonathan Foy
    Nov 19, 2009 at 5:06 pm
    Nov 23, 2009 at 4:47 pm
  • I have a table with a number of columns. I perform Select * from table order by a,b There is an index on a,b which is clustered (as well as indexes on a and b alone). I have issued the cluster and ...
    Jonathan BlitzJonathan Blitz
    Nov 22, 2009 at 1:07 pm
    Nov 23, 2009 at 2:11 pm
  • Does/is it possible for the PG optimizer come up with differnet plans when you're using bind variables vs when you send static values? like if my query was select * from users (add a bunch of complex ...
    David KerrDavid Kerr
    Nov 3, 2009 at 5:51 pm
    Nov 5, 2009 at 5:47 am
  • Dear all, The query is slow when executing in the stored procedure(it is taking around 1 minute). when executing as a sql it is taking 4 seconds. basically i am selecting the varchar column which ...
    Nov 24, 2009 at 5:45 am
    Nov 24, 2009 at 6:29 am
  • Regards to all the list. ZFS, the new filesystem developed by the Solaris Development team and ported to FreeBSD too, have many advantages that can do that all sysadmins are questioned about if it is ...
    Ing . Marcos Luís Ortíz ValmasedaIng . Marcos Luís Ortíz Valmaseda
    Nov 30, 2009 at 3:46 am
    Nov 30, 2009 at 12:35 pm
  • Hi, My PostgreSQL server has two CPUs (OS: Fedora 11), each with 4 cores. Total is 8cores. Now I have several clients running at the same time to do insert and update on the same table, each client ...
    Nov 21, 2009 at 10:57 pm
    Nov 23, 2009 at 7:20 pm
  • Hello everbody, I´m doing some tests with a large table about 7 milions tuples. So, I need to retrieve only the last value for some key. That key has about 20.000 tuples in this table. SELECT field1 ...
    Nov 18, 2009 at 4:18 pm
    Nov 18, 2009 at 4:30 pm
  • Dear All, Thanks very much for your help so far. My understanding of PG is getting a lot better! I wonder if I've understood analyze properly: I'm not sure I quite understand how specific the ...
    Richard NeillRichard Neill
    Nov 25, 2009 at 12:34 pm
    Nov 25, 2009 at 3:22 pm
  • Question: Is an INSERT command with a SELECT statement in the RETURNING * parameter faster than say an INSERT and then a SELECT? Does the RETURNING * parameter simply amount to a normal SELECT ...
    Jason DictosJason Dictos
    Nov 23, 2009 at 9:13 pm
    Nov 25, 2009 at 2:40 pm
  • Hi All, I have a stats collection system where I collect stats at specific intervals (from network monitoring nodes), and stuff them into a PostgreSQL DB. To make make the retrieval faster, I'm using ...
    Hrishikesh (हृषीकेश मेहेंदळे)Hrishikesh (हृषीकेश मेहेंदळे)
    Nov 20, 2009 at 1:23 am
    Nov 20, 2009 at 4:42 pm
  • Hello, we are facing a performance regression regarding certain NOT EXISTS clauses when moving from 8.3.8 to 8.4.1. It is my understanding that the planer treats LEFT JOINs and NOT EXISTS equally ...
    Wiktor WodeckiWiktor Wodecki
    Nov 17, 2009 at 1:30 pm
    Nov 18, 2009 at 8:18 am
  • Hi All, We have a bigger table with some million rows. Number of index scans is high, number of seq reads is low. This table if often joined with others... so we want to buy a new SSD drive, create a ...
    Laszlo NagyLaszlo Nagy
    Nov 9, 2009 at 12:59 pm
    Nov 9, 2009 at 4:04 pm
  • Hi folks I had a couple of semi-newbie questions about this, which I couldn't find obvious answers to in the archives ... we are using Postgres 8.3, and the behaviour is the same across Windows and ...
    Dave CrookeDave Crooke
    Nov 4, 2009 at 9:19 pm
    Nov 4, 2009 at 9:52 pm
  • All, I'm trying to understand the free memory usage and why it falls below 17G sometimes and what could be causing it. Any pointers would be appreciated. root@prod1 # prtconf System Configuration: ...
    Subbiah Stalin-XCGF84Subbiah Stalin-XCGF84
    Nov 3, 2009 at 7:25 pm
    Nov 4, 2009 at 10:35 am
  • I have a million-row table (two text columns of ~25 characters each plus two integers, one of which is PK) that is replaced every week. Since I'm doing it on a live system, it's run inside a ...
    Craig JamesCraig James
    Nov 30, 2009 at 6:50 pm
    Nov 30, 2009 at 7:32 pm
  • Hi all Why age (datfrozenxid) in postgres becomes 1073742202 not zero after vacuum of database. Thanks in advance Brahma Prakash Tiwari DBA Think before you print.|Go green
    Brahma Prakash TiwariBrahma Prakash Tiwari
    Nov 12, 2009 at 8:27 am
    Nov 13, 2009 at 9:05 pm
  • Hi Chaps, I'm putting together some new servers, and whilst I've been happy with our current config of Adaptec 5805's with bbu I've noticed these 5805Z cards, apparently the contents of DRAM is ...
    Glyn AstillGlyn Astill
    Nov 11, 2009 at 6:46 pm
    Nov 11, 2009 at 9:27 pm
  • This is just a heads-up for anyone using Ruby on Rails (with ActiveRecord) on JRuby who sees performance degradation over time. Each Ruby runtime instance will degrade query performance slightly. You ...
    Kevin GrittnerKevin Grittner
    Nov 12, 2009 at 4:50 pm
    Nov 12, 2009 at 4:50 pm
  • There's two papers published recently at Duke that I just found, both of which use PostgreSQL as part of their research: Automated SQL Tuning through Trial and (Sometimes) Error: ...
    Greg SmithGreg Smith
    Nov 11, 2009 at 12:32 am
    Nov 11, 2009 at 12:32 am
Group Navigation
period‹ prev | Nov 2009 | next ›
Group Overview
grouppgsql-performance @

97 users for November 2009

Scott Marlowe: 35 posts Greg Smith: 33 posts Richard Neill: 24 posts Tom Lane: 23 posts Robert Haas: 18 posts Kevin Grittner: 15 posts Craig Ringer: 14 posts Matthew Wakeling: 13 posts Merlin Moncure: 13 posts Grzegorz Jaśkiewicz: 11 posts Laszlo Nagy: 9 posts Craig James: 8 posts Dave Crooke: 8 posts Laurent Laborde: 8 posts Eddy Escardo-Raffo: 7 posts Ivan Voras: 7 posts Scott Carey: 7 posts Karl Denninger: 6 posts Lorenzo Allegrucci: 6 posts Pavel Stehule: 6 posts
show more