FAQ

PostgreSQL > pgsql-performance > January 2008

Search Discussions

40 discussions - 302 posts

  • Hi List; We'll be loading a table with begining & ending I.P.'s - the table will likely have upwards of 30million rows. Any thoughts on how to get the best performance out of queries that want to ...
    Kevin KempterKevin Kempter
    Jan 10, 2008 at 11:15 pm
    Jan 14, 2008 at 2:12 pm
  • Hi all, we have a PostgreSQL dedicated Linux server with 8 cores (2xX5355). We came accross a strange issue: when running with all 8 cores enabled approximatly once a minute (period differs) the ...
    Jakub OuhrabkaJakub Ouhrabka
    Jan 3, 2008 at 11:51 am
    Mar 22, 2008 at 1:44 am
  • Hey folks -- For starters, I am fairly new to database tuning and I'm still learning the ropes. I understand the concepts but I'm still learning the real world impact of some of the configuration ...
    Joshua FielekJoshua Fielek
    Jan 23, 2008 at 4:12 am
    Jan 25, 2008 at 8:18 am
  • Hi We recently converted to postgres (from mssql) and we're having performance issues. Not all the issues are related to postgres, but we're trying to sort everything out. The server is running ...
    Adrian MoiseyAdrian Moisey
    Jan 9, 2008 at 8:18 am
    Jan 10, 2008 at 2:35 pm
  • Hi I've noticed a strange pattern in our logs. We only log anything that takes longer then 5 seconds. If I tail the logs, I see a steady stream of functions that took longer then 5 seconds. But every ...
    Adrian MoiseyAdrian Moisey
    Jan 16, 2008 at 10:42 am
    Jan 21, 2008 at 7:37 pm
  • A simple update query, over roughly 17 million rows, populating a newly added column in a table, resulted in an out of memory error when the process memory usage reached 2GB. Could this be due to a ...
    Stephen DenneStephen Denne
    Jan 25, 2008 at 12:32 am
    Jan 28, 2008 at 8:18 am
  • I might completely misunderstand this feature. Shouldn't "synchronous_commit = off" improve performance? Whatever I do, I find "synchronous_commit = off" to degrade performance. Especially it doesn't ...
    Hannes DorbathHannes Dorbath
    Jan 21, 2008 at 10:03 pm
    Jan 22, 2008 at 12:34 pm
  • My set-up: Postgres 8.2.5 on AMD x86_64 compiled with GCC 3.4.4 on Gentoo Linux 2.6.17 4 GB of RAM, shared_buffers = 1000 work_mem = 1024 This is regarding performance of set-returning functions in ...
    John SmithJohn Smith
    Jan 9, 2008 at 2:21 am
    Jun 10, 2008 at 12:48 am
  • Hi We are looking to buy a new server and I am wondering what kind of hardware we should buy and how to configure it. We are either getting 8x 2.5" 15k rpm sas disks or 6x 3.5" 15k rpm sas disks. If ...
    Christian NicolaisenChristian Nicolaisen
    Jan 28, 2008 at 7:26 pm
    Jan 29, 2008 at 6:41 pm
  • Hi, I have been having difficulty with some functions which return sets of rows. The functions seem to run very slowly, even though the queries they run execute very quicky if I run them directly ...
    Dean RasheedDean Rasheed
    Jan 20, 2008 at 11:40 am
    Jan 28, 2008 at 12:39 pm
  • We have a machine that serves as a fileserver and a database server. Our server hosts a raid array of 40 disk drives, attached to two3-ware cards, one 9640SE-24 and one 9640SE-16. We have noticed ...
    Sean DavisSean Davis
    Jan 17, 2008 at 8:17 pm
    Jan 19, 2008 at 4:21 pm
  • I've got two huge tables with one-to-many relationship with complex key. There's also a view, which JOINs the tables, and planner chooses unoptimal plan on SELECTs from this view. The db schema is ...
    Dmitry PotapovDmitry Potapov
    Jan 23, 2008 at 1:51 pm
    Jan 31, 2008 at 11:40 am
  • hi We have an installation of Postgres 8.1.2 (32bit on Solaris 9) with a DB size of about 250GB on disk. The DB is subject to fair amount of inserts, deletes and updates per day. Running VACUUM ...
    Thomas LozzaThomas Lozza
    Jan 23, 2008 at 6:34 pm
    Jan 28, 2008 at 7:52 pm
  • Hi I am investigating migrating from postgres 743 to postgres 826 but although the performance in postgres 826 seems to be generally better there are some instances where it seems to be markedly ...
    Matthew LunnonMatthew Lunnon
    Jan 28, 2008 at 11:41 am
    Jan 28, 2008 at 3:54 pm
  • I'm not sure what is going on but looking for some advice, knowledge. I'm running multiple postgres servers in a slon relationship. I have hundreds of thousands of updates, inserts a day. But what ...
    Tory M BlueTory M Blue
    Jan 23, 2008 at 6:24 pm
    Jan 28, 2008 at 6:09 am
  • Hi, I'd appreciate some assistance in working through what would be the optimal configuration for the following situation. We currently have one large DB (~1.2TB on disk), that essentially consists ...
    David BrainDavid Brain
    Jan 25, 2008 at 4:38 pm
    Jan 28, 2008 at 4:25 am
  • Hi ms I have a query which runs pretty quick ( 0.82ms) but when I put it inside a stored procedure it takes 10 times as long (11.229ms). Is this what you would expect and is there any way that I can ...
    Matthew LunnonMatthew Lunnon
    Jan 28, 2008 at 12:03 pm
    Feb 5, 2008 at 10:07 am
  • Useing 8.1.9 I'm running into some performance issues with inheritance. I've abstracted the situation below because otherwise there's lots of spurious stuff, but I'll gladly provide the real EXPLAIN ...
    Julian ScarfeJulian Scarfe
    Jan 12, 2008 at 7:34 pm
    Jan 13, 2008 at 8:48 pm
  • Hi, I've got a pg database, and a batch process that generates some metadata to be inserted into one of the tables. Every 15 minutes or so, the batch script re-calculates the meta data (600,000 ...
    GrowseGrowse
    Jan 25, 2008 at 11:27 pm
    Feb 1, 2008 at 1:51 am
  • Hi All, I am experiencing a strange performance issue with Postgresql (7.4.19) + PostGIS. (I posted to the PostGIS list but got no response, so am trying here.) We have a table of entries that ...
    Claire McListerClaire McLister
    Jan 28, 2008 at 5:59 pm
    Jan 31, 2008 at 7:30 pm
  • Hi Which scheduler is recommended for a box that is dedicated to running postgres? I've asked google and found no answers. -- Adrian Moisey System Administrator | CareerJunction | Your Future Starts ...
    Adrian MoiseyAdrian Moisey
    Jan 22, 2008 at 7:00 am
    Jan 22, 2008 at 8:46 am
  • Using Postgresql 8.1.10 every so often I get a transaction that takes a while to commit. I log everything that takes over 500ms and quite reguallly it says things like 707.036 ms statement: COMMIT Is ...
    Peter ChildsPeter Childs
    Jan 3, 2008 at 2:35 pm
    Jan 4, 2008 at 10:17 am
  • Hi -performance, While testing 8.3, I found this query which is equally slow on 8.1 and 8.3 and seems to be really slow for a not so complex query. The stats are as good as possible and the behaviour ...
    Guillaume SmetGuillaume Smet
    Jan 23, 2008 at 12:57 am
    Jan 23, 2008 at 9:06 am
  • Hi, Since I moved from PostgreSQL 7.3 to 8.2 I have a query which suddenly runs very slow. In 7.3 it was really fast. It seems that the query analyser makes other choices, which I don't understand. I ...
    Marten VerhoevenMarten Verhoeven
    Jan 21, 2008 at 3:00 pm
    Jan 21, 2008 at 6:04 pm
  • Hi, I am having a really hard time trying to figure out why my simple count(*) query is taking so long. I have a table with 1,296,070 rows in it. There are 2 different types of information that each ...
    James DeMicheleJames DeMichele
    Jan 12, 2008 at 1:36 am
    Jan 12, 2008 at 5:44 am
  • Hello, I have an interesting generic search task, for which I have done different performance tests and I would like to share and discuss my results on this newsgroup. So I begin to describe the ...
    Jörg KiegelandJörg Kiegeland
    Jan 9, 2008 at 10:43 am
    Jan 10, 2008 at 12:06 pm
  • Hi All, I have a procedure which contains only one Select statement. The procedure take more time than expected to complete, the select statement inside the procedure was taking about 2 minutes to ...
    Anoo Sivadasan PillaiAnoo Sivadasan Pillai
    Jan 9, 2008 at 4:11 am
    Jan 9, 2008 at 6:06 pm
  • Hi. Running postgres 8.2 on debian. I've noticed that concurrent inserts (archiving) of large batches data into two completely unrelated tables are many times slower than the same inserts done in ...
    Sergei ShelukhinSergei Shelukhin
    Jan 6, 2008 at 3:21 am
    Jan 7, 2008 at 11:08 pm
  • Hi How long is a piece of string? While we're at it, how often do I vacuum analyze? Seriously though, how do I try measure this? -- Adrian Moisey System Administrator | CareerJunction | Your Future ...
    Adrian MoiseyAdrian Moisey
    Jan 29, 2008 at 2:29 pm
    Jan 29, 2008 at 6:40 pm
  • We are trying to optimize our Database server without spending a fortune on hardware. Here is our current setup. Main Drive array: 8x 750 GB SATA 2 Drives in a RAID 10 Configuration, this stores the ...
    Alex HochbergerAlex Hochberger
    Jan 28, 2008 at 1:54 pm
    Jan 29, 2008 at 2:56 am
  • On a linux box (Linux db1 2.6.18.8-md #1 SMP Wed May 23 17:21:37 EDT 2007 i686 GNU/Linux) I edited postgresql.conf and changed: shared_buffers = 5000 work_mem = 16384 max_stack_depth = 4096 and then ...
    Rick SchumeyerRick Schumeyer
    Jan 24, 2008 at 6:41 pm
    Jan 25, 2008 at 2:59 am
  • Hi, There will be some flames i suppose. Well I've a normalized database.. For instance: create table Y ( pk, data... ); create table Z ( pk , data... ); create table X ( char, references Y, ...
    PatricPatric
    Jan 14, 2008 at 6:19 pm
    Jan 15, 2008 at 3:30 am
  • Greetings, I was trying to get informations on #portgresql about a query plan I think is quite strange, and I was said to post on this list. I hope my mail will be clear enough. I have included the ...
    Yannick Le GuédartYannick Le Guédart
    Jan 14, 2008 at 2:18 pm
    Jan 14, 2008 at 7:06 pm
  • I cannot get the "not exists" clause of ANSI SQL to execute correctly. select t.col11, t.col1... from table1 t where not exists (select 1 from table2 where col2 = t.col1); table1 has 40M + rows. if ...
    S GollyS Golly
    Jan 10, 2008 at 8:15 pm
    Jan 11, 2008 at 4:01 am
  • Hello, I'm developing some routines that will use temporary tables and need advice on how to not lose performance. I will insert data in a temporary table and use this data to generate new sets that ...
    Luiz K. MatsumuraLuiz K. Matsumura
    Jan 22, 2008 at 7:42 pm
    Jan 22, 2008 at 8:34 pm
  • All, I have been asked to move this thread to the performance list. Below is the full discussion to this point. Doug Knight WSI Corp Andover, MA -------- Forwarded Message -------- From: Doug Knight ...
    Doug KnightDoug Knight
    Jan 15, 2008 at 5:05 pm
    Jan 18, 2008 at 10:50 pm
  • I have the following problem: In my table T, there are a fixed number of boolean columns, C1, .., Cn. Now, a common query is to search in this table for tuples fullfilling an arbitrary boolean ...
    Jörg KiegelandJörg Kiegeland
    Jan 11, 2008 at 5:06 pm
    Jan 11, 2008 at 5:42 pm
  • Hello, I have a problem with my install of postgresql. I have a program that requests DB by opening persistent connexions. When the program is launched, the disk IO are very high until postgresql ...
    Guillaume PungeotGuillaume Pungeot
    Jan 8, 2008 at 3:36 pm
    Jan 9, 2008 at 12:09 am
  • Hi Tom, Is it still valid for 8.3 or is there any reason to change this recommendation, considering the work you did on the planner during the 8.3 cycle? Thanks. -- Guillaume
    Guillaume SmetGuillaume Smet
    Jan 23, 2008 at 12:42 pm
    Jan 23, 2008 at 12:42 pm
  • No, it stops growing. @sanjeev We are using "..\pgAdmin III\1.6\pg_dump.exe" -i -h IPHOST -p 5432 -U user -F c -b -v -f "..\back\myfile.backup" db We are going to try the other one. @Harald, we've ...
    Sebastián BaioniSebastián Baioni
    Jan 2, 2008 at 12:24 pm
    Jan 2, 2008 at 12:24 pm
Jan 2008
Group Navigation
period‹ prev | Jan 2008 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions40
posts302
users94
websitepostgresql.org
irc#postgresql

94 users for January 2008

Tom Lane: 36 posts Scott Marlowe: 19 posts Adrian Moisey: 13 posts Greg Smith: 13 posts Michael Stone: 13 posts Jakub Ouhrabka: 11 posts Guillaume Smet: 8 posts Joshua D. Drake: 8 posts Matthew Lunnon: 8 posts Merlin Moncure: 7 posts Florian Weimer: 6 posts Alvaro Herrera: 5 posts Matthew: 5 posts Stephen Denne: 5 posts Steve Atkins: 5 posts David: 4 posts Andrew Sullivan: 4 posts Dean Rasheed: 4 posts Heikki Linnakangas: 4 posts Jörg Kiegeland: 4 posts
show more
Archives