>> Question, though: is HP still using their proprietary RAID
>card? And, if so,
>> have they fixed its performance problems?
>
>According to my folks here, we're using the CCISS controllers, so I
>guess they are. The systems are nevertheless performing very well --
>we did a load test that w
> In the past week, one guy of Unix Group in Colombia
> say: "Postgrest in production is bat, if the power off in any
> time the datas is lost why this datas is in plain files.
> Postgrest no ssupport data bases with more 1 millon of records".
> Wath tell me in this respect?, is more best Inform
> ["very, very offtopic"]
> Ok. This comparition is just as useless as the other one,
> because it's comparing oranges with apples (It's funny
> anyway). I was just choosing an example in which you can see
> the best of postgresql against 'not so nice' behavior of
> mssql2000 (no service pack,
> Hi,
>
> I have a perfomance issue :
>
> I run PG (8.0.3) and SQLServer2000 on a Windows2000 Server
> (P4 1,5Ghz 512Mo) I have a table (320 rows) and I run
> this single query :
>
> select cod from mytable group by cod
> I have an index on cod (char(4) - 88 different values)
>
> PG = ~ 2
> > It appears that PostgreSQL is two to three times slower
> than MySQL.
> > For example, some pages that have some 30,000 characters
> (when saved
> > as HTML) take 1 to 1 1/2 seconds with MySQL but 3 to 4 seconds with
> > PostgreSQL. I had read that the former was generally
> faster than
> > This smells like a TCP communication problem.
>
> I'm puzzled by that remark. How much does TCP get into the
> picture in a local Windows client/server environment?
Windows has no Unix Domain Sockets (no surprise there), so TCP
connections over the loopback interface are used to connect
> > I've done the tests with rc1. This is still as slow on windows ...
> about
> > 6-10
> > times slower thant linux (via Ip socket). (depending on
> using prepared
> > queries, etc...)
> >
> > By the way, we've tried to insert into the windows database from a
> linux
> > psql
> > client, via th
> 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
> > > 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
> > 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
> > > 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
>
> > 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
> >> 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
> 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
> > 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
> >>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
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
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
> 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
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
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 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
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 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
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 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 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 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
> 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
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
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
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
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
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/
>>
>>
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
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
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
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
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
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 ---
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 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
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
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
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:
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 ([email protected])
To
> 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)
> > 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.
> > > > 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
> > >
> > > 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
> 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
> > 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
> > 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
> > > 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
> > > > > 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
>
> 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
> 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
> > 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
> 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
> > 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
>
> 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
> 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,
> 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
> > 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
> > > "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
> 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
> > > 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... ;-)
>
>
>> Having to recompile to run on single- vs dual-processor
>machines doesn't
>> seem like it would fly.
>
>Oh, I don't know. Many applications require compiling for a target
>architecture; SQL Server, for example, won't use a 2nd
>processor without
>re-installation. I'm not sure about Oracle
>> How do vendors actually implement auto-clustering? I assume
>they move
>> rows around during quiet periods or have lots of empty space in each
>> value bucket.
>
>
>As far as I know, Oracle does it by having a B-Tree organized heap (a
>feature introduced around v8 IIRC), basically making the p
>Hi,
>
>We are experiencing slow performance on 8 Beta 2 Dev3 on Win32 and are
>trying to determine why. Any info is appreciated.
>
>We have a Web Server and a DB server both running Win2KServer with all
>service packs and critical updates.
>
>An ASP page on the Web Server hits the DB Server with a
> > > This was an intersting Win32/linux comparison. I expected
> Linux to
> > > scale better, but I was surprised how poorly XP scaled. It
> > > reinforces our perception that Win32 is for low traffic servers.
> >
> > That's a bit harsh given the lack of any further
> investigation so far
>
> > I'm hoping someone can shed some light on these results.
>
> Not without a lot more detail on how you *got* the results.
> What exactly did you do to force the various plan choices?
> (I see some ridiculous choices of indexscans, for instance,
> suggesting improper use of enable_seqscan i
>Josh Berkus wrote:
>> Now you can see why other DBMSs don't use the OS disk cache. There's
>> other
>> issues as well; for example, as long as we use the OS disk cache, we
>can't
>> eliminate checkpoint spikes, at least on Linux. No matter what we do
>with
>> the bgwriter, fsyncing the OS disk c
>> I don't think that's correct either. Scatter/Gather I/O is
>used to SQL
>> Server can issue reads for several blocks from disks into it's own
>> buffer cache with a single syscall even if these buffers are not
>> sequential. It did make significant performance improvements
>when they
>> added
>I've downloaded the latest release (PostgreSQL 8.0) for windows.
>Installation was OK, but I have tried to restore a database.
>It had more than ~100.000 records. Usually I use PostgreSQL
>under Linux, and it used to be done under 10 minutes.
>
>Under W2k und XP it took 3 hours(!) Why is it so sl
> Hi,
>
> I changed fsync to false. It took 8 minutes to restore the
> full database.
> That is 26 times faster than before. :-/ (aprox. 200 tps)
> With background writer it took 12 minutes. :-(
That seems reasonable.
> The funny thing is, I had a VMWARE emulation on the same
> Windows mashi
> > You can *never* get above 80 without using write cache,
> regardless of
> > your OS, if you have a single disk.
>
> Why? Even with, say, a 15K RPM disk? Or the ability to
> fsync() multiple concurrently-committing transactions at once?
Uh. What I meant was a single *IDE* disk. Sorry. Been
> >> What platform is this on? It seems very strange/fishy
> that all the
> >> actual-time values are exact integral milliseconds.
>
> > My machine is WinXP professional, athon xp 2100, but I get similar
> > results on my Intel P4 3.0Ghz as well (which is also
> running WinXP).
> > Why do y
> > Do we need actual high precision time, or do we just need
> to be able
> > to get high precision differences? Getting the differences
> is fairly
> > easy, but if you need to "sync up" any drif then it becomes
> a bit more
> > difficult.
>
> You're right, we only care about differences n
> > RDTSC is a bad source of information for this kind of thing, as the
> > CPU frequency might vary.
>
> One thought that was bothering me was that if the CPU goes
> idle while waiting for disk I/O, its clock might stop or slow
> down dramatically.
> If we believed such a counter for EXPLAIN,
> One thing that stands out is how terribly bad Windows
> performed with many small single transactions and fsync=true.
>
> Appearantly fsync on Windows is a very costly operation.
What's the hardware? If you're running on disks with write cache
enabled, fsync on windows will write through the
> > >The "this day and age" argument isn't very convincing. Hard drive
> > >capacity growth has far outstripped hard drive seek time
> and bandwidth improvements.
> > >Random access has more penalty than ever.
> >
> > In point of fact, there haven't been noticeable seek time
> improvements
> >
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
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
-
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
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:
>> 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
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
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
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
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
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
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
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
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
[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
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
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
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
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
1 - 100 of 126 matches
Mail list logo
