On Oct 16, 2014 12:58 AM, "Tom Lane" wrote:
>
> Igor Neyman writes:
> > From: Dave Johansen [mailto:davejohan...@gmail.com]
> > This conversation has probably become a bit off topic, but my
understanding is that what you're paying RedHat for is a stable platform
for a long period of time. That me
ally works. Probably such sort of
> knowledge is so essential for a DBA, that it is better to learn both
> methods, at least to be able to choose correctly? But maybe it is a
> rhetorical question.
>
> On Tue, Mar 25, 2014 at 4:21 PM, Magnus Hagander
> wrote:
> > I would say that
> To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgsql-performance
>
>
>
> --
> Ilya Kosmodemiansky,
>
> PostgreSQL-Consulting.com
> tel. +14084142500
> cell. +4915144336040
> i...@postgresql-consulting.com
>
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
On Oct 22, 2013 1:14 AM, "Tomas Vondra" wrote:
>
> On 22.10.2013 00:59, sparikh wrote:
> > Yes, Expalin without Analyze is taking long. It is weird. In the
> > pg_stat_activity Explain was the only query running. So server was
> > almost idle. Using New relic interface I checked CPU was almost idl
ement ?
You can use something like SELECT pg_get_indexdef(indexrelid) FROM
pg_index. You will need to filter it not to include system indexes,
toast, etc, and then insert the CONCURRENCY part, but it should give
you a good startingpoint.
--
Magnus Hagander
Me: http://www.hagander.net/
Work
NCURRENTLY, and then rename the new one into place (typically
in a transaction). (If your app, documentation or dba doesn't mind the
index changing names, you don't need to rename of course, you can just
drop the old one).
--
Magnus Hagander
Me: http://www.hagander.net/
Work: ht
re about your archive you could set your
archive_command to e.g. /bin/true, and that will make it pretend it
has archived the files, and should clean it up quicker. But that will
mean you have no valid archive and thus no valid backups, until you
start over froma new base.
--
Magnus Hagander
Me
e
> database - this seems wrong to me, however I have no clue why this would
> happen.
My first guess would be that your archive_command is failing - so
check your logs for that. If that command fails, no xlog files will
ever be rotated (since it would invalidate your backups).
--
y to deal with the
"we lost data sometime between and but don't know when" when
tracking it down. I've yet to find a case where that's not easier than
repeatedly restoring even a fairly small pg_dump based backup to find
it. Plus, it give you a much better granularity,
rprise me if it's
not possible.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
On Mon, Aug 6, 2012 at 4:16 PM, Pavel Stehule wrote:
> 2012/8/6 Magnus Hagander :
>> That's not a good way of doing it, since you loose persistent storage.
>>
>> Instead, you should set the stats_temp_dir paramter to a filesystem
>> somewhere else that is tmpfs. Th
ther server with similar problems
>> on 9.1.
>>
>> Any help would be sincerely appreciated.
>>
>>
>> David Barton d...@oneit.com.au
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
u have a single tablespace you can have pg_basebackup write the
output to stdout and then pipe that through pigz.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes
e raid controller does
> 'write-throughs' on the attached disks, and the SSD's don't lie about when
> they've written to RAM.
Doesn't most SSDs without supercaps lie about the writes, though?
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www
han as an extra module or app
that you have to patch your kernel with. Unless you can get it all the
way into the baseline kernel of course, but that's not going to be
easy...
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgs
certainly hope
it didn't take years to clean up ;) So I wouldn't hold my breath for
that one.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
what can I do to make the first query use its index
> on the primary key.
Looks like the first table is not partitioned, but the second one is?
PostgreSQL 9.0 is unable to use an index scan to find min/max on a
partitioned table. 9.1, however, can do that.
--
Magnus Hagander
Me: http:
idea to choose your clustering technology
based on the web interfaces... Running 3 pgpooladmin doesn't seem like
a huge thing.
And you should note that PostgresXC is nowhere near production ready.
It'll get there, but it's pretty far away.
--
Magnus Hagander
Me: http://www.haga
dn't want to make
themselves dependant on an Oracle controlled technology. That argument
certainly went away when Oracle bought them - and I think that was the
main reason. Not the "oracle mindset" or anything like that...
--
Magnus Hagander
Me: http://www.hagander.net/
Work: htt
tested?
Yes.
> - Is the linux support of the LSI and Adaptec cards comparable?
Can't comment on that one, sorry.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To
you'll get weird errors about failed transactions til
> rollback etc.
Yeah, AFAIK pgbouncer works fine on Windows, and is a very good pooler
for PostgreSQL. I haven't run it on Windows myself, but it should
support it fine...
--
Magnus Hagander
Me: http://www.hagander.net/
Work:
a bit of downtime. Just sticking a 1-1 mapping pgbouncer
in between with support for SUSPEND makes a lot of difference if you
switch master/slave on your replication /ha. It'll still break the
connections for jboss, but it'll recover from that a *lot* faster than
a reconfig.
--
Magnus
n't want to push the extensibility of PostgreSQL there?
+1 on this idea in general, if we can think up a good API - this seems
very useful to me, and you have some good examples there of cases
where it'd definitely be a help.
--
Magnus Hagander
Me: http://www.hagander.net/
Wor
On Mon, Jun 14, 2010 at 15:59, Tom Lane wrote:
> Magnus Hagander writes:
>> On Sun, Jun 13, 2010 at 21:19, David Jarvis wrote:
>>> I prefer to_timestamp and to_date over the more verbose construct_timestamp.
>
>> Yeah, I agree with that.
>
> Those names
requires both year and month etc?
> I prefer to_timestamp and to_date over the more verbose construct_timestamp.
Yeah, I agree with that.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-performance mailing list (pgsql-performance@
On Sun, Jun 13, 2010 at 17:58, Tom Lane wrote:
> Magnus Hagander writes:
>> On Sun, Jun 13, 2010 at 17:42, Tom Lane wrote:
>>> ... (We presumably want
>>> timezone to default to the system timezone setting, but I wonder how
>>> we should make that work ---
On Sun, Jun 13, 2010 at 17:42, Tom Lane wrote:
> Magnus Hagander writes:
>> On Sun, Jun 13, 2010 at 09:38, David Jarvis wrote:
>>> Does it makes sense to use named parameter notation for the first value (the
>>> year)? This could be potentially confusing:
&g
the others are
so arbitrary there is no way to explain such a choice.
> Similarly, to_timestamp() ...? Seems meaningless without at least a full
> date and an hour.
Agreed.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-pe
n will by default to SSL on your connection
which obviously adds a *lot* of overhead. If you're not actively using
it (in which case you will control this from pg_hba.conf), just edit
postgresql.conf and disable SSL, then restart the server.
--
Magnus Hagander
Me: http://www.hag
;
> I've no idea of the other needed NTFS tweaks, like if there is a
> noatime/nodiratime ?...
It does. See
http://www.hagander.net/talks/Advanced%20PostgreSQL%20on%20Windows.pdf
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
S
On Tue, Sep 22, 2009 at 15:19, Alan McKay wrote:
> On Tue, Sep 22, 2009 at 2:42 AM, Magnus Hagander wrote:
>> That's not true at all.
>>
>> If you have many relations in your cluster that have at some point been
>> touched, the starts collector can create
On 21 sep 2009, at 23.41, Bruce Momjian wrote:
Alan McKay wrote:
And if so, where does that extra load go? ? ?Disk? ?CPU? ?RAM?
As of 8.4.X the load isn't measurable.
Thanks Bruce. What about 8.3 since that is our current production
DB?
Same. All statsistics settings that are enabled
that you don't have to struggle with tuning the FSM in 8.4 is another
thing that makes life a *lot* easier in this kind of installations.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-performance mailing list (pgsql-performance
Schedule a run of a couple of representative queries right as the
database has started? That should pre-populate the cache before your
users get there, hopefully.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-performance mailing li
onnection pooling. Is there
> some more variants to use connection pooling without using postgres users?
Not that I know of.
--
Magnus Hagander
Self: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
--
Sent via pgsql-performance mailing list (pgsql-performance@postgre
Tom Lane wrote:
> Linos writes:
>> Tom Lane escribió:
>>> That's just weird --- ssl off should be ssl off no matter which knob you
>>> use to turn it off. Are you sure it's really off in the slow connections?
>
>> Maybe i am missing something, i use the same command to connect to it
>> from loca
[EMAIL PROTECTED] wrote:
> On Thu, 28 Aug 2008, Scott Marlowe wrote:
>>> wait a min here, postgres is supposed to be able to survive a
>>> complete box
>>> failure without corrupting the database, if killing a process can
>>> corrupt
>>> the database it sounds like a major problem.
>>
>> Yes it is
Joshua D. Drake wrote:
>
>
> On Wed, 2008-05-28 at 16:59 -0700, Josh Berkus wrote:
> > Folks,
>
> > shared_buffers: according to witnesses, Greg Smith presented at
> > East that based on PostgreSQL's buffer algorithms, buffers above
> > 2GB would not really receive significant use. However, Ji
Jessica Richard wrote:
> I have a large table with about 2 million rows and it will keep
> growing...
>
> I need to do update/inserts, and select as well.
>
> An index will speed up the select, but it will slow down the updates.
>
> Are all Postgres indexes ordered? i.e., with every update, the
Potluri Srikanth wrote:
> Hi all,
>
> I need to do a bulk data loading around 704GB (log file size) at
> present in 8 hrs (1 am - 9am). The data file size may increase 3 to
> 5 times in future.
>
> Using COPY it takes 96 hrs to finish the task.
> What is the best way to do it ?
>
> HARDWARE: S
Matthew wrote:
On Wed, 13 Feb 2008, Rory Campbell-Lange wrote:
4 x 147GB 15000 rpm SCSI in RAID 10 with 320-1 RAID CARD + 64MB
cache BBU
2x Intel Xeon E5405 / 4x 2.00GHz / 1333MHz FSB / 12MB cache
6GB RAM
Cost around 2320 GBP -- it would be great to get it under 2000
Needs to be
Roberts, Jon wrote:
Subject: Re: [PERFORM] 8.3rc1 Out of memory when performing update
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
poor choic
On Thu, Dec 27, 2007 at 01:10:29AM -0500, Tom Lane wrote:
> Greg Smith <[EMAIL PROTECTED]> writes:
> > On Wed, 26 Dec 2007, Guillaume Smet wrote:
> >> beta RPMs are by default compiled with --enable-debug and
> >> --enable-cassert which doesn't help them to fly fast...
>
> > Got that right. Last
On Tue, Dec 11, 2007 at 07:50:17AM -0800, Craig James wrote:
> Alvaro Herrera wrote:
> >>>...Since you've now shown that OpenBabel is
> >>>multithreaded, then that's a much more likely cause.
> >>Can you elaborate? Are multithreaded libraries not allowed to be
> >>linked to Postgres?
> >
> >Absolu
Campbell, Lance wrote:
> How can I clear the pg_stats views without restarting PostgreSQL? I
> thought there was a function.
pg_stat_reset()
//Magnus
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archi
Ow Mun Heng wrote:
>> You're likely better off (performance-wise) putting it on the same disk
>> as the database itself if that one has better RAID, for example.
>
> I'm thinking along the lines of since nothing much writes to the OS
> Disk, I should(keyword) be safe.
Unless it's *always* in the
Ron St-Pierre wrote:
> Joe Uhl wrote:
>> I realize there are people who discourage looking at Dell, but i've been
>> very happy with a larger ball of equipment we ordered recently from
>> them. Our database servers consist of a PowerEdge 2950 connected to a
>> PowerVault MD1000 with a 1 meter SAS
Ow Mun Heng wrote:
> On Wed, 2007-10-31 at 22:58 +0100, Tomas Vondra wrote:
>
>> 2) separate the transaction log from the database
>>
>> It's mostly written, and it's the most valuable data you have. And in
>> case you use PITR, this is the only thing that really needs to be
>> backed
Tomas Vondra wrote:
>> How does pg utilize multiple processors? The more the better?
>
> Linux version uses processes, so it's able to use multiple processors.
> (Not sure about Windows version, but I guess it uses threads.)
No, the Windows version also uses processes.
//Magnus
-
Ketema wrote:
> I am trying to build a very Robust DB server that will support 1000+
> concurrent users (all ready have seen max of 237 no pooling being
> used). I have read so many articles now that I am just saturated. I
> have a general idea but would like feedback from others.
>
> I understa
Tino Wildenhain wrote:
> Magnus Hagander schrieb:
>> I'd consider having a small daemon LISTENing for NOTIFYs that you send
>> by triggers whenever the table has changed. That'll make sure it only
>> dumps if something actually changed. And you can also implement
I'd consider having a small daemon LISTENing for NOTIFYs that you send by
triggers whenever the table has changed. That'll make sure it only dumps if
something actually changed. And you can also implement some ratelimiting if
needed.
/Magnus
> --- Original Message ---
> From: "Jeffrey
Joshua D. Drake wrote:
> Steinar H. Gunderson wrote:
>> On Mon, Jul 09, 2007 at 11:57:13AM -0400, Jignesh K. Shah wrote:
>>> I think this result will be useful for performance discussions of
>>> postgresql against other databases.
>>>
>>> http://www.spec.org/jAppServer2004/results/res2007q3/
>>
>>
Tom Lane wrote:
> PFC <[EMAIL PROTECTED]> writes:
>>> What version of PostgreSQL are you using?
>
>> I think newbies should be pushed a bit to use the latest versions,
>
> How about pushed *hard* ? I'm constantly amazed at the number of people
> who show up in the lists saying they installe
Sachchida Ojha wrote:
> Hi,
>
> I am new to PostgreSQL database. Can anybody help me (or point me the
> related post) to install PostgreSQL on windows XP from command line.
> (From .bat file)
http://pginstaller.projects.postgresql.org/silent.html
//Magnus
---(end of broa
James Mansion wrote:
> Alexander Staubo wrote:
>> On 5/23/07, Andy <[EMAIL PROTECTED]> wrote:
>>> An example would be:
>>> SELECT * FROM table
>>> WHERE name like '%john%' or street like
>>> '%srt%'
>>>
>>> Anyway, the query planner always does seq scan on the whole tab
Harald Armin Massa wrote:
> Heikki,
>
>
>> > PostgreSQL on Windows. My current rule of thumb on Windows: set
>> > shared_buffers to minimum * 2
>> > Adjust effective_cache_size to the number given as "system cache"
>> > within the task manager.
>>
>> Why?
>
> I tried with shared_buffers = 50% of
> Thanks for all the feedback. Unfortunately I didn't specify that this
> is running on a WinXP machine (the 3D renderer is an ActiveX plugin),
> and I don't even think "nice" is available. I've tried using the
> Windows Task Manager to set every postgres.exe process to a low
> priority, but th
On Thu, May 03, 2007 at 10:45:48AM -0400, Greg Smith wrote:
> Today's survey is: just what are *you* doing to collect up the
> information about your system made available by the various pg_stat views?
> I have this hacked together script that dumps them into a file, imports
> them into another
On Fri, Apr 27, 2007 at 08:10:48AM +, Andres Retzlaff wrote:
> Hi Magnus,
>
> in this case each CPU goes up to 50%, giveing me 50% total usage. I was
> specting as you say 1 query 100% cpu.
>
> Any ideas?
No. 1 query will only use 100% of *one* CPU, which means 50% total usage.
You need at
On Fri, Apr 27, 2007 at 04:43:06AM +, Andres Retzlaff wrote:
> 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.
A single query w
On Tue, Mar 20, 2007 at 10:18:45AM -0400, Merlin Moncure wrote:
> On 3/20/07, Ireneusz Pluta <[EMAIL PROTECTED]> wrote:
> >Hello all,
> >
> >I sent a similar post to a FreeBSD group, but thought I'd might try here
> >too.
> >
> >I am completing a box for PostgreSQL server on FreeBSD. Selecting a R
On Thu, Mar 08, 2007 at 06:24:35AM -, James Mansion wrote:
>
> In the long run, we are going to have to seriously rethink pg's use
> of WAL as the way we implement MVCC as it becomes more and more of a
> performance bottleneck.
> We have WAL because Stonebreaker made an assumption about the fu
Tom Lane wrote:
> "Merlin Moncure" <[EMAIL PROTECTED]> writes:
>> On 3/2/07, Tom Lane <[EMAIL PROTECTED]> wrote:
>>> "Merlin Moncure" <[EMAIL PROTECTED]> writes:
I think this explains the trigger that was blowing up my FC4 box.
>>> I dug in the archives a bit and couldn't find the report you'r
On Thu, Mar 01, 2007 at 12:49:14AM -0500, Jonah H. Harris wrote:
> On 3/1/07, Shiva Sarna <[EMAIL PROTECTED]> wrote:
> >I am sorry if it is a repeat question but I want to know if database
> >performance will decrease if I increase the max-connections to 2000. At
> >present it is 100.
>
> Most cer
On Tue, Feb 27, 2007 at 06:36:11PM -0500, Charles Sprickman wrote:
> On Tue, 27 Feb 2007, Dave Page wrote:
>
> >Magnus Hagander wrote:
> >>
> >>Just as a datapoint, we did try to use mnogosearch for the
> >>postgresql.org website+archives search, and it fell
On Mon, Feb 26, 2007 at 04:24:12PM -0500, Charles Sprickman wrote:
> On Mon, 26 Feb 2007, Madison Kelly wrote:
>
> >Hi all,
> >
> >I'd really like to come up with a more intelligent search engine that
> >doesn't take two minutes to return results. :) I know, in the end good
> >indexes and underl
> Joshua, I've been digging around the CVS (web) looking for the search
> engine code but so far have only found the reference (www.search) in
> 'general.php' but can't locate the file. You wouldn't happen to have a
> direct link would you?
It's all in module "portal". You will find the indexing
Alvaro Herrera wrote:
> Steinar H. Gunderson wrote:
>> On Fri, Feb 23, 2007 at 02:05:57PM -0500, Geoffrey wrote:
>>> In searching the archives, I can't find any specific info indentifying
>>> which Xeon processors don't have this problem.
>> AFAIK the cut-off point is at the Woodcrests. They are o
Jeremy Haile wrote:
> I am sure that this has been discussed before, but I can't seem to find
> any recent posts. (I am running PostgreSQL 8.2)
>
> I have always ran PostgreSQL on Linux in the past, but the company I am
> currently working for uses Windows on all of their servers. I don't
> have
> > > You may try to figure out what's the process doing (the backend
> > > obviously, not the frontend (Tcl) process) by attaching
> to it with
> > > strace.
> >
> > It's so sad when us poor Windows guys get helpful hints from people
> > assume that we're smart enough to run *NIX... ;-)
>
>
> Hello Performancers,
>
> has anyone a pgBench tool running on Windows?
Does the one that ships in the installer not work?
//Magnus
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs
> > > "anonymous mapped memory" site:microsoft.com turns out 0 (zero)
> > > results. And even splitting it up there seems to be nearly no
> > > information ... is the same thing by any chance also known by
> > > different names?
> >
> > Hmm. Yeah, most likely :) I may have grabbed that name fro
> > So: has anybody a hint how I can check how much shared_memory
> > is really used by PostgreSQL on Windows, to fine tune
> this parameter?
> >
> > I learned the hard way that just rising it can lead to a hard
> > performance loss :)
>
> Not really sur
> Hello,
>
> Shridhar Daithankar and Josh Berkus write on
> http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
>
> shared_memory
>
> """
> There is one way to decide what is best for you. Set a high
> value of this parameter and run the database for typical
> usage. Watch usage of
> Hi,
>
> We are seeing hanging queries on Windows 2003 Server SP1 with dual
> CPU, looks like one of the process is blocked. In a lot of cases,
> the whole DB is blocked if this process is holding important locks.
>
> Looks like this issue was discussed in the following thread a few
> month ago,
> There is 64MB on the 6i and 192MB on the 642 controller. I wish the
> controllers had a "wrieback" enable option like the LSI MegaRAID
> adapters have. I have tried splitting the cache accelerator 25/75
> 75/25 0/100 100/0 but the results really did not improve.
They have a writeback option, but
> > First off - very few third party tools support debian. Debian is
> a
> > sure fire way to have an unsupported system. Use RedHat or SuSe
> > (flame me all you want, it doesn't make it less true).
>
> *cough* BS *cough*
>
> Linux is Linux. It doesn't matter what trademark you put on top of
>
> MSSQL can give either a graphical query plan or a text-based
> one similar to PG. There's no way that I've found to get the
> equivalent of an EXPLAIN ANALYZE, but I'm by no means an MSSQL guru.
SET STATISTICS IO ON
SET STATISTICS PROFILE ON
SET STATISTICS TIME ON
//Magnus
> > I beleive the function to kill a backend is actually in the
> codebase,
> > it's just commented out because it's considered dangerous.
> There are
> > some possible issues (see -hackers archives) about sending SIGTERM
> > without actually shutting down the whole cluster.
> >
> > Doing the
> There have been dozens, perhaps hundreds, of entries in the
> pg-admin, pg-general, and pg-performance lists regarding
> killing a session, but as far as I can tell, there is no
> Postgres solution. Did I miss something?
>
> This raises the question: Why doesn't Postgres have a "kill
> sess
> PostgreSQL elects not to use them. I assume, because it most
> likely needs to traverse the entire table anyway.
>
> if i change: / substr(t0.code,1,2) not in
> ('14','15','16','17')/
> to (removing the NOT): /substr(t0.code,1,2) in
> ('14','15','16','17')/
>
> it uses the i
> > > > > FWIW, I've found problems running PostgreSQL on Windows in a
> > > > > multi-CPU environment on w2k3. It runs fine for some
> period, and
> > > > > then CPU and throughput drop to zero. So far I've
> been unable to
> > > > > track down any more information than that, other than the
>
> > > FWIW, I've found problems running PostgreSQL on Windows in a
> > > multi-CPU environment on w2k3. It runs fine for some period, and
> > > then CPU and throughput drop to zero. So far I've been unable to
> > > track down any more information than that, other than the
> fact that
> > > I h
> > Bacula already serializes access to the database (they have
> to support
> > mysql/myisam), so this shouldn't help.
>
> Ouch, that hurts.
>
> To support mysql, they break performance for _every other_
> database system?
Actually, it probably helps on SQLite as well. And considering they o
> > For now, I only could get good performance with bacula and
> postgresql
> > when disabling fsync...
>
>
> Isn't that less safe?
Most definitly.
FWIW, I'm getting pretty good speeds with Bacula and PostgreSQL on a
reasonably small db (file table about 40 million rows, filename about
5.2 mi
> This is a blatant thread steal... but here we go...
> Do people have any opinions on the pgsql driver?
It's very nice.
> How does it compare with the odbc in terms of performance?
I haven't measured specifically, but if you're tlaking .net it should be
better. It's all in managed code, so you
> > > Could it be they broke it when they did that
> >
> > In theory, yes, but it still seems a bit far fetched :-(
>
> Well, I rolled back SP1 and am running my test again. Looking
> much better, hasn't locked up in 45mins now, whereas before
> it would lock up within 5mins.
>
> So I think
> > > > I dunno
> > > >
> > > > > if you've got anything gdb-equivalent under Windows,
> but that's
> > > > > the first thing I'd be interested in ...
> > > >
> > > > Here ya go:
> > > >
> > > > http://www.devisser-siderius.com/stack1.jpg
> > > > http://www.devisser-siderius.com/stack2.jpg
> > >
> > Is it possible to get a stack trace from the stuck process?
> I dunno
> > if you've got anything gdb-equivalent under Windows, but that's the
> > first thing I'd be interested in ...
>
> Here ya go:
>
> http://www.devisser-siderius.com/stack1.jpg
> http://www.devisser-siderius.com/stack2.
> Is it possible to get a stack trace from the stuck process?
> I dunno if you've got anything gdb-equivalent under Windows,
> but that's the first thing I'd be interested in ...
Try Process Explorer from www.sysinternals.com.
//Magnus
---(end of broadcast)
> >>That way if someone wanted to upgrade from 7.2 to 8.1, they
> can just
> >>grab the latest dumper from the website, dump their old
> database, then
> >>upgrade easily.
> >
> > But if they're upgrading to 8.1, don't they already have the new
> > pg_dump? How else are they going to dump the
> > Perhaps we should put a link on the home page underneath LATEST
> > RELEASEs saying
> > 7.2: de-supported
> >
> > with a link to a scary note along the lines of the above.
> >
> > ISTM that there are still too many people on older releases.
> >
> > We probably need an explanation of why
> Because I think we need to. The above would only delete rows
> that have name = 'obsid' and value = 'oid080505'. We need to
> delete all rows that have the same ids as those rows.
> However, from what you note, I bet we could do:
>
>DELETE FROM "tmp_table2" WHERE id IN
> (SELECT
> >> AFAICS it is appropriate to move the sigsetjmp and
> >> setup_cancel_handler calls in front of the per-line loop inside
> >> MainLoop --- can anyone see a reason not to?
>
> > hm. mainloop is re-entrant, right? That means each \i
> would reset the
> > handler...what is downside to keepin
> > I'm inclined to treat this as an outright bug, not just a minor
> certainly...
>
> > performance issue, because it implies that a sufficiently long psql
> > script would probably crash a Windows machine.
>
> actually, it's worse than that, it's more of a dos on the
> whole system, as window
> > > I'd like to use the win32 provided recv(), send()
> functions instead
> > > of redirect them to pgwin32_recv()/pgwin32_send(), just
> like libpq
> > > does. If we do this, we will lose some functionalities,
> but I'd like
> > > to see the performance difference first. -- do you think
>
> > Sorry, I don't follow you here - what do you mean to do? Remove the
> > event completely so we can't wait on it?
> >
>
> I'd like to use the win32 provided recv(), send() functions
> instead of redirect them to pgwin32_recv()/pgwin32_send(),
> just like libpq does. If we do this, we will lo
> > > Both win32 send/recv have pgwin32_poll_signals() in them.
> > > This is glorified WaitForSingleObjectEx on global
> > > pgwin32_signal_event. This is probably part of the problem.
> > > Can we work some of the same magic you put into check interrupts
> > > macro?
> > >
> >
> > Uh, we alrea
> Both win32 send/recv have pgwin32_poll_signals() in them.
> This is glorified WaitForSingleObjectEx on global
> pgwin32_signal_event. This is probably part of the problem.
> Can we work some of the same magic you put into check
> interrupts macro?
>
> ISTM everything also in win32 functio
1 - 100 of 126 matches
Mail list logo
