Search Discussions

39 discussions - 457 posts

  • Hi, any idea if there is a more optimal execution plan possible for this query: select S.REF as stref, S.NAME as stnm, H.HORDER as hord, H.BEGIN_DATE as hbeg, H.END_DATE as hend, H.NOTE as hnote from ...
    May 6, 2009 at 7:42 am
    May 20, 2009 at 11:50 am
  • HI. Someone had some experience of bad performance with postgres in some server with many processors? I have a server with 4 CPUS dual core and gives me a very good performance but I have experienced ...
    May 28, 2009 at 6:51 pm
    Jun 5, 2009 at 7:48 pm
  • Hi, Recent change postgresql server from Amazon EC2 small into large one. That gives me x86_64 arch, two core cpu and 7.5GB ram. Atm got almost ~2000 small databases at that server and autovacuum ...
    Łukasz JagiełłoŁukasz Jagiełło
    May 24, 2009 at 8:06 pm
    Jun 9, 2009 at 4:43 pm
  • I keep falling into situations where it would be nice to host a server somewhere else. Virtual host solutions and the mysterious cloud are no good for the ones I run into though, as disk performance ...
    Greg SmithGreg Smith
    May 26, 2009 at 9:51 pm
    Jun 11, 2009 at 12:16 pm
  • Hi, We have one query which has a left join. If we run this query without the left join, it runs slower than with the left join. -query with the left join: EXPLAIN ANALYZE SELECT artifact.id AS id, ...
    Anne RossetAnne Rosset
    May 28, 2009 at 10:59 pm
    Jun 2, 2009 at 3:41 pm
  • Hello, i have to buy a new server and in the budget i have (small) i have to select one of this two options: -4 sas 146gb 15k rpm raid10. -8 sas 146gb 10k rpm raid10. The server would not be only ...
    May 21, 2009 at 12:54 pm
    May 22, 2009 at 5:25 pm
  • Hi, I was looking at the support that PostgreSQL offers for table partitioning at http://www.postgresql.org/docs/8.4/static/ddl-partitioning.html. The concept looks promising, but its maybe fair to ...
    Henk de witHenk de wit
    May 1, 2009 at 2:32 pm
    May 9, 2009 at 1:26 am
  • I have a query [1] that Postgres is insisting on using a Nested Loop for some reason when a Hash Join is much faster. It seems like the estimates are way off. I've set default_statistics_target to ...
    David BlewettDavid Blewett
    May 7, 2009 at 5:01 pm
    Jun 6, 2009 at 2:02 am
  • I have 3 servers, all with identical databases, and each performing very differently for the same queries. www3 is my fastest, www2 is the worst, and www1 is in the middle... even though www2 has ...
    Erik AronestyErik Aronesty
    May 31, 2009 at 9:59 am
    Jun 6, 2009 at 2:17 am
  • Hi, what may you suggest as the most optimal postgresql.conf to keep writing as stable as possible?.. What I want is to avoid "throughput waves" - I want to keep my response times stable without any ...
    May 11, 2009 at 4:15 pm
    May 12, 2009 at 3:41 pm
  • Hi, I need to store data about sensor readings. There is a known (but configurable) number of sensors which can send update data at any time. The "current" state needs to be kept but also all ...
    Ivan VorasIvan Voras
    May 28, 2009 at 12:54 pm
    May 28, 2009 at 7:44 pm
  • Anyone on the list had a chance to benchmark the Nehalem's yet? I'm primarily wondering if their promise of performance from 3 memory channels holds up under typical pgsql workloads. I've been really ...
    Scott MarloweScott Marlowe
    May 12, 2009 at 11:36 pm
    May 14, 2009 at 5:10 pm
  • Hi all, recently I came across a question from a customer of mine, asking me if it would feasible to run PostgreSQL along with PostGIS on embedded hardware. They didn't give me complete information, ...
    Paolo RizziPaolo Rizzi
    May 8, 2009 at 4:13 pm
    May 13, 2009 at 3:04 pm
  • autovacuum has been running on 2 tables for 5 hours. There tables are not huge (see below). For the past ~1 hour, I've shut off all other activity on this database. The other table being vacuumed has ...
    Brian CoxBrian Cox
    May 29, 2009 at 11:56 pm
    May 31, 2009 at 9:15 pm
  • Hi, Some context, we have a _lot_ of data, 1TB, mostly in 1 'table' - the 'datatable' in the example below although in order to improve performance this table is partitioned (by date range) into a ...
    David BrainDavid Brain
    May 7, 2009 at 2:20 pm
    May 9, 2009 at 9:43 am
  • Hi have the following table (theoretical) table apartment_location ( city_id int, street_id int, house_id int, floor_id int, owner string ... ) index .. ( city_id, street_id, house_id, floor_id ) ...
    Thomas FinneidThomas Finneid
    May 12, 2009 at 11:51 pm
    May 14, 2009 at 11:54 am
  • Hi, I'm hoping you guys can help with improving this query I'm having a problem with. The main problem is that the query plan changes depending on the value of the LIMIT clause, with small values ...
    James NelsonJames Nelson
    May 1, 2009 at 8:15 am
    May 1, 2009 at 3:42 pm
  • Hey folks, I have done some googling and found a few things on the matter. But am looking for some suggestions from the experts out there. Got any good pointers for reading material to help me get up ...
    Alan McKayAlan McKay
    May 27, 2009 at 5:57 pm
    May 27, 2009 at 7:58 pm
  • So Google hasn't been helpful and I'm not entirely sure what to look for in the mailing lists to find the answer to my problem, so here goes. I have a query and I have run explain analyze select ...
    Zach CalvertZach Calvert
    May 27, 2009 at 3:17 pm
    May 27, 2009 at 5:10 pm
  • Dear List mates, more optimal plan... morreoptimal configuration... we suffer a 'more optimal' superlative missuse there is not so 'more optimal' thing but a simple 'better' thing. im not native ...
    Angel AlvarezAngel Alvarez
    May 13, 2009 at 12:06 am
    May 15, 2009 at 2:21 am
  • Friendly greetings ! I found something "odd" (something that i can't explain) this weekend. An octocore server with 32GB of ram, running postgresql 8.3.6 Running only postgresql, slony-I and ...
    Laurent LabordeLaurent Laborde
    May 4, 2009 at 8:15 am
    May 5, 2009 at 11:42 am
  • I have the following table: CREATE TABLE "temp".tmp_135528 ( id integer NOT NULL, prid integer, group_id integer, iinv integer, oinv integer, isum numeric, osum numeric, idate timestamp without time ...
    Евгений ВасилевЕвгений Василев
    May 12, 2009 at 9:10 am
    Nov 22, 2009 at 8:07 am
  • I was glad to find in 8.3.7 that pg was now smart enough to use an index for a simple UNION ALL. But unfortunately, it's not quite there yet for our use case. Consider the following dummy tables: ...
    Brad JorschBrad Jorsch
    May 14, 2009 at 2:37 pm
    May 14, 2009 at 3:22 pm
  • Hi I am wondering what stripe size, on a raid 0, is the most suitable for postgres 8.2? I read a performance tutorial by Bruce Momjian and it suggest setting the stripe size to the same block size ...
    Thomas FinneidThomas Finneid
    May 13, 2009 at 7:51 am
    May 13, 2009 at 9:50 am
  • I'm running version 8.1.11 on SLES 10 SP2. I'm trying to improve this query and unfortunately I cannot change the application. For some reason the planner is making a bad decision sometimes after an ...
    Cory CoagerCory Coager
    May 11, 2009 at 9:22 pm
    May 12, 2009 at 11:36 pm
  • I'm running a rather complex query and noticed a peculiarity in the usage of statistics that seriously affects the plan generated. I can extract the relevant bit: modmine-r9=# select * from pg_stats ...
    Matthew WakelingMatthew Wakeling
    May 8, 2009 at 1:46 pm
    May 8, 2009 at 4:16 pm
  • Hello, I want to use postgresql for data entries (every minute) from a central heating system where the timestamp is logged in a table log. For flexibility in the future for future values and for ...
    Gerhard WiesingerGerhard Wiesinger
    May 1, 2009 at 1:56 pm
    Sep 27, 2009 at 7:10 am
  • Hey folks, During Greg Smith's lecture last week I could have sworn I saw on the screen at some point a really long command line for bonnie++ - with all the switches he uses. But checking his slides ...
    Alan McKayAlan McKay
    May 27, 2009 at 1:24 pm
    May 27, 2009 at 4:01 pm
  • Dear Friends, How to insert or update a file in a table using the query in postgres CREATE TABLE excel_file_upload ( user_id integer, excel_file bytea } example insert into excel_file_upload ...
    May 27, 2009 at 6:49 am
    May 27, 2009 at 12:05 pm
  • I just upgraded from a 2xIntel Xeon-Harpertown 5450-Quadcore,16 GB,Redhat EL 5.1-64 To 2xIntel Xeon-Nehalem 5570-Quadcore,36GB,Redhat EL 5.3-64 Any advice on how I'll get the best of this server? ...
    Kobby DapaahKobby Dapaah
    May 20, 2009 at 4:22 pm
    May 21, 2009 at 5:47 am
  • Hi everybody, I'm wondering why a DELETE statement of mine does not make use of defined indexes on the tables. I have the following tables which are linked as such: component - rank - node - corpus; ...
    Viktor RosenfeldViktor Rosenfeld
    May 7, 2009 at 10:47 pm
    May 8, 2009 at 10:18 am
  • Is there a way to limit I/O bandwidth/CPU usage of a certain backend? It seems that ionice/renice makes no sense because of bgwriter/WAL writer processes are not a part of a backend. I have a ...
    Vlad ArkhipovVlad Arkhipov
    May 5, 2009 at 7:31 am
    May 6, 2009 at 5:11 am
  • Hmmm. Anyone out there have the Continuent solution working with PostgreSQL? If so, what release? We're at 8.3 right now. thanks, -Alan p.s. I'm continuing the cross-post because that is the way I ...
    Alan McKayAlan McKay
    May 28, 2009 at 4:15 pm
    May 29, 2009 at 12:26 am
  • Hi, I have sen many posts on using SSDs, and iodrive <http://www.fusionio.com in particular, to accelerate the performance of Postgresql (or other DBMS) -- e.g. this ...
    Shaul DarShaul Dar
    May 25, 2009 at 1:55 pm
    May 26, 2009 at 4:00 pm
  • Hi all, iam having trouble with a query, in this query we have parameters, to indicate the starting month and the ending month (commented line in the query). You can see the explain using the ...
    Daniel FerreiraDaniel Ferreira
    May 21, 2009 at 11:52 am
    May 21, 2009 at 3:41 pm
  • Dear Friends, How to insert or update a file in a table using the query in postgres CREATE TABLE excel_file_upload ( user_id integer, excel_file bytea } example insert into excel_file_upload ...
    May 27, 2009 at 6:49 am
    May 27, 2009 at 6:49 am
  • Hi All, Not sure if this is the right pgsql-* "channel" to post to, but I was hoping maybe someone could answer a question from one of my fellow developers. Please read below: If there's any ...
    Richard YenRichard Yen
    May 21, 2009 at 11:17 am
    May 21, 2009 at 11:17 am
  • Rohan Pethkar wants you to join Yaari! Is Rohan your friend? <a href="http://yaari.com/?controller=user&action=mailregister&friend=1&sign=YaariFTL554VBZ483SLB511BDO643" Yes, Rohan is my friend!</a <a ...
    Rohan PethkarRohan Pethkar
    May 11, 2009 at 5:47 am
    May 11, 2009 at 5:47 am
  • Rohan Pethkar wants you to join Yaari! Is Rohan your friend? <a href="http://yaari.com/?controller=user&action=mailregister&friend=1&sign=YaariFTL554VBZ483SLB511BDO643" Yes, Rohan is my friend!</a <a ...
    Rohan PethkarRohan Pethkar
    May 8, 2009 at 5:47 am
    May 8, 2009 at 5:47 am
Group Navigation
period‹ prev | May 2009 | next ›
Group Overview
grouppgsql-performance @

95 users for May 2009

Dimitri: 54 posts Tom Lane: 38 posts Scott Marlowe: 27 posts Simon Riggs: 27 posts Scott Carey: 22 posts Robert Haas: 19 posts Greg Smith: 18 posts Matthew Wakeling: 15 posts Grzegorz Jaśkiewicz: 11 posts Alvaro Herrera: 10 posts David Blewett: 8 posts Fabrix: 8 posts Merlin Moncure: 8 posts Joshua D. Drake: 7 posts Kenneth Marshall: 7 posts Kevin Grittner: 6 posts Scott Mead: 6 posts Brian Cox: 5 posts Dimitri Fontaine: 5 posts Heikki Linnakangas: 5 posts
show more