Search Discussions

42 discussions - 422 posts

  • The semi-join and anti-join have helped us quite a bit, but we have seen a situation where anti-join is chosen even though it is slower than the "old fashioned" plan. I know there have been other ...
    Kevin GrittnerKevin Grittner
    Nov 9, 2010 at 9:19 pm
    Jan 27, 2011 at 1:41 am
  • This is not a request for help but a report, in case it helps developers or someone in the future. The setup is: AMD64 machine, 24 GB RAM, 2x6-core Xeon CPU + HTT (24 logical CPUs) FreeBSD ...
    Ivan VorasIvan Voras
    Nov 22, 2010 at 12:16 am
    Dec 9, 2010 at 1:41 am
  • The database for monitoring certain drone statuses is quite simple: CREATE TABLE samples ( sample_id integer not null primary key, sample_timestamp timestamp not null default now() ); CREATE TABLE ...
    Mario SplivaloMario Splivalo
    Nov 28, 2010 at 12:12 pm
    Dec 13, 2010 at 3:30 am
  • I have 2 tables with a 200,000 rows of data 3 character/string columns ID, Question and Response. The query below compares the data between the 2 tables based on ID and Question and if the Response ...
    Humair MohammedHumair Mohammed
    Nov 15, 2010 at 8:14 pm
    Nov 23, 2010 at 2:20 pm
  • Hi there. If you just wanted PostgreSQL to go as fast as possible WITHOUT any care for your data (you accept 100% dataloss and datacorruption if any error should occur), what settings should you use ...
    A BA B
    Nov 5, 2010 at 10:59 am
    Jan 27, 2011 at 5:07 pm
  • This is my first post in this mailing list and I would like to raise an issue that in my opinion is causing performance issues of PostgreSQL especially in a transaction processing environment. In my ...
    Kyriacos KyriacouKyriacos Kyriacou
    Nov 11, 2010 at 7:09 pm
    Nov 30, 2010 at 12:22 am
  • Hello We have an application that needs to do bulk reads of ENTIRE Postgres tables very quickly (i.e. select * from table). We have observed that such sequential scans run two orders of magnitude ...
    Nick MathesonNick Matheson
    Nov 3, 2010 at 4:52 pm
    Nov 5, 2010 at 10:04 pm
  • Hi, I am trying to tune my libpq program for insert performance. When I tried inserting 1M rows into a table with a Primary Key, it took almost 62 seconds. After adding a composite index of 2 ...
    Divakar SinghDivakar Singh
    Nov 1, 2010 at 12:49 pm
    Nov 2, 2010 at 8:32 pm
  • Hi, I have to collect lots of prices from web sites and keep track of their changes. What is the best option? 1) one 'price' row per price change: create table price ( id_price primary key, ...
    Louis-David MitterrandLouis-David Mitterrand
    Nov 16, 2010 at 10:57 am
    Nov 20, 2010 at 4:28 pm
  • This is not directly a PostgreSQL performance question but I'm hoping some of the chaps that build high IO PostgreSQL servers on here can help. We build file transfer acceleration s/w (and use ...
    Eric ComeauEric Comeau
    Nov 17, 2010 at 3:01 pm
    Nov 20, 2010 at 10:16 am
  • Hello We have an application that needs to do bulk reads of ENTIRE Postgres tables very quickly (i.e. select * from table). We have observed that such sequential scans run two orders of magnitude ...
    Dan SchafferDan Schaffer
    Nov 1, 2010 at 2:15 pm
    Dec 17, 2010 at 1:51 pm
  • I have a postgres 8.4.5 instance on CentOS 5 (x86_64) which appears to go crazy with the amount of memory it consumes. When I run the query below, in a matter of a few seconds memory balloons to 5.3G ...
    Jon NelsonJon Nelson
    Nov 6, 2010 at 12:27 am
    Nov 24, 2010 at 3:11 am
  • Hello, I have a very large table that I'm not too fond of. I'm revising the design now. Up until now its been insert only, storing tracking codes from incoming webtraffic. It has 8m rows It appears ...
    Nov 26, 2010 at 2:22 pm
    Dec 7, 2010 at 10:37 pm
  • Hello Friends, I have many instances of my software running on a server (Solaris SPARC). Each software instance requires some DB tables (same DDL for all instances' tables) to store data. It ...
    Divakar SinghDivakar Singh
    Nov 25, 2010 at 11:37 am
    Nov 26, 2010 at 11:38 am
  • Hi, I have a table employee with 33 columns. The table have 200 records now. Select * from employee takes 15 seconds to fetch the data!!! Which seems to be very slow. But when I say select id,name ...
    Nov 8, 2010 at 6:36 am
    Nov 8, 2010 at 6:42 pm
  • All, Domas (of Facebook/Wikipedia, MySQL geek) pointed me to this report: http://www.phoronix.com/scan.php?page=article&item=linux_perf_regressions&num=1 ...
    Josh BerkusJosh Berkus
    Nov 5, 2010 at 8:15 pm
    Nov 5, 2010 at 10:29 pm
  • Hi, I have a question about the behavior of autovacuum. When I have a big table A which is being processed by autovacuum, I also manually use (full) vacuum to clean another table B. Then I found that ...
    Nov 12, 2010 at 8:01 am
    Nov 21, 2010 at 4:25 pm
  • I have some simple query (executed with time command): time psql -c 'explain analyze SELECT te.idt FROM t_positions AS te JOIN t_st AS stm ON (te.idt=stm.idt AND 4=stm.idm) WHERE te.idtr IN (347186)' ...
    Artur Zaj±cArtur Zaj±c
    Nov 15, 2010 at 8:42 am
    Nov 15, 2010 at 9:30 pm
  • hello, i have a big performance problem with some views which would joined (from the third party tool crystal reports) to print a document. view1: SELECT ... FROM personen.kunde kunde, ...
    Markus SchulzMarkus Schulz
    Nov 24, 2010 at 7:02 pm
    Dec 4, 2010 at 6:46 pm
  • I wrote a little Perl script, intended to test the difference that array insert makes with PostgreSQL. Imagine my surprise when a single record insert into a local database was faster than batches of ...
    Mladen GogalaMladen Gogala
    Nov 2, 2010 at 7:46 pm
    Nov 10, 2010 at 9:42 am
  • Hi, I have a query that is getting a pretty bad plan due to a massively incorrect count of expected rows. All tables in the query were vacuum analyzed right before the query was tested. Disabling ...
    Nov 9, 2010 at 9:26 pm
    Nov 10, 2010 at 12:10 am
  • All, Having an interesting issue on one 8.4 database. Due to poor application design, the application is requesting 8-15 exclusive (update) locks on the same row on parallel connections pretty much ...
    Josh BerkusJosh Berkus
    Nov 17, 2010 at 5:38 pm
    Nov 17, 2010 at 11:56 pm
  • I have simple database schema, containing just three tables: samples, drones, drones_history. Now, those tables hold data for the drones for a simulation. Each simulation dataset will grow to around ...
    Mario SplivaloMario Splivalo
    Nov 28, 2010 at 12:02 pm
    Nov 30, 2010 at 10:35 pm
  • explain SELECT crmentity.crmid, crmentity.setype, crmentity.modifiedtime, activity.subject,case when ( users.user_name not like '') then users.user_name else groups.groupname end as user_name, ...
    AI RummanAI Rumman
    Nov 29, 2010 at 7:00 am
    Nov 29, 2010 at 3:03 pm
  • I use the postgresql in default configuration and use inheritance way to create table. My postgresql version is: SELECT version(); version ...
    Nov 10, 2010 at 9:52 am
    Nov 14, 2010 at 11:01 pm
  • Question regarding the operation of the shared_buffers cache and implications of the pg_X_stat_tables|pg_X_stat_indexes stats. ( I am also aware that this is all complicated by the kernel cache ...
    Mark RostronMark Rostron
    Nov 7, 2010 at 8:33 pm
    Nov 12, 2010 at 9:07 pm
  • I have a query that's running an IN/Subselect that joins three different tables and gets a list of IDs to compare against... the subselect basically looks for records through a join table based on ...
    Nov 30, 2010 at 6:19 pm
    Dec 1, 2010 at 1:44 am
  • Hello, in the last years, we have successfully manage to cope with our data growth using partitioning and splitting large aggregation tasks on multiple threads. The partitioning is done logically by ...
    Marc MaminMarc Mamin
    Nov 11, 2010 at 1:41 pm
    Nov 11, 2010 at 8:05 pm
  • Where can I find the documentation describing the buffer replacement policy? Are there any parameters governing the page replacement policy? -- Mladen Gogala Sr. Oracle DBA 1500 Broadway New York, NY ...
    Mladen GogalaMladen Gogala
    Nov 3, 2010 at 4:35 pm
    Nov 5, 2010 at 8:58 pm
  • Hi, I am working on a performance issue with a partitioned table. Some of my sql statements against this partition table is in waiting state for long time. I have queried waiting=true in ...
    Nov 30, 2010 at 11:38 am
    Nov 30, 2010 at 4:55 pm
  • Hello. How to use tid scans? This below not works :-( Always is used merge join. DROP TABLE IF EXISTS test1; CREATE TABLE test1 as select i,hashint4(i)::text from generate_series(1,10000) as a(i); ...
    Pasman PasmańskiPasman Pasmański
    Nov 30, 2010 at 11:43 am
    Nov 30, 2010 at 4:50 pm
  • Hello. I have a query which works a bit slow. It's runned on desktop computer: AMD Athlon X2 2GHz , Win Xp sp2, 1GB ram. Postgres 8.4.5 with some changes in config: shared_buffers = 200MB # min 128kB ...
    Pasman PasmańskiPasman Pasmański
    Nov 24, 2010 at 2:48 pm
    Nov 26, 2010 at 3:06 pm
  • dear pgers -- consider the following toy example (using pg 8.4.3) : create temporary table foo ( ts timestamp not null, id integer not null, val double precision not null, primary key (ts, id) ); i ...
    Nov 11, 2010 at 9:53 pm
    Nov 11, 2010 at 11:56 pm
  • Hello together, I get an out of memory problem I don't understand. The installed Postgres-Version is: PostgreSQL 8.3.7 on i486-pc-linux-gnu, compiled by GCC gcc-4.3.real (Debian 4.3.3-5) 4.3.3 It is ...
    Till KirchnerTill Kirchner
    Nov 9, 2010 at 10:47 am
    Nov 9, 2010 at 4:02 pm
  • Hi Sorry, my previous post haven't shown in this list, so I repost this one. I have a sql become very slow after upgrade to 8.4.5. The table creation sql like this. begin; CREATE TABLE t_a ( id INT ...
    Nov 2, 2010 at 2:50 am
    Nov 3, 2010 at 1:47 am
  • Hi, I'm experiencing extremely different response times for some complex pgsql functions. extremly different means from 20ms - 500ms and up to 20s. I have to say that the complete database fits in ...
    Uwe BartelsUwe Bartels
    Nov 18, 2010 at 10:10 am
    Dec 3, 2010 at 5:16 pm
  • Hi all, I am new to Postgres. I just wanted to know how to change the sleep time. I want to reduce the sleep time, How much will it affect other performance issues if sleep time is reduced. Plz help. ...
    Aaliya zarrinAaliya zarrin
    Nov 29, 2010 at 4:39 am
    Nov 29, 2010 at 5:10 am
  • Hi, I am using Postgresql: 9.01, PostGIS 1.5 on FreeBSD 7.0. I have at least one table on which SELECT's turn terribly slow from time to time. This happened at least three times, also on version 8.4. ...
    Martin BoeseMartin Boese
    Nov 22, 2010 at 8:59 am
    Nov 22, 2010 at 3:12 pm
  • Trying to understand why query planer changes the plan from effective one to ineffective one when I change the offset in the LIMIT. Also, thankfully accepting RTFM pointers to the actual FMs. Setup ...
    Nov 19, 2010 at 12:55 pm
    Nov 21, 2010 at 3:44 pm
  • Hello everybody, having this SQL query: -------------- select variable_id,float_value,ts,good_through,interval,datetime_value,string_value,int_value,blob_value,history_value_type from ...
    Martin ChlupacMartin Chlupac
    Nov 18, 2010 at 11:09 am
    Nov 18, 2010 at 1:33 pm
  • I was doing some testing with temporary tables using this sql: begin; select pg_sleep(30); create temporary TABLE foo (a int, b int, c int, d text); insert into foo SELECT (x%1000) AS a,(x%1001) AS ...
    Jon NelsonJon Nelson
    Nov 13, 2010 at 1:53 pm
    Nov 13, 2010 at 2:57 pm
  • Can you hear me now? -- Mladen Gogala Sr. Oracle DBA 1500 Broadway New York, NY 10036 (212) 329-5251 http://www.vmsinfo.com The Leader in Integrated Media Intelligence Solutions
    Mladen GogalaMladen Gogala
    Nov 2, 2010 at 9:21 pm
    Nov 3, 2010 at 3:51 pm
Group Navigation
period‹ prev | Nov 2010 | next ›
Group Overview
grouppgsql-performance @

91 users for November 2010

Tom Lane: 36 posts Kevin Grittner: 28 posts Robert Haas: 22 posts Mladen Gogala: 16 posts Marti Raudsepp: 15 posts Tomas Vondra: 15 posts Greg Smith: 14 posts Andres Freund: 13 posts Pavel Stehule: 12 posts Jon Nelson: 11 posts Pierre C: 11 posts Josh Berkus: 10 posts Cédric Villemain: 9 posts Ivan Voras: 9 posts Scott Carey: 9 posts Humair Mohammed: 8 posts Kenneth Marshall: 8 posts Mario Splivalo: 8 posts Bricklen: 7 posts Divakar Singh: 7 posts
show more