--with this
marked exception--performs pretty spectacularly, all told.
/rls
--
Rosser Schwarz
Total Card, Inc.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL
temprod.did = cust.origid;
Not quite. Without this update, acount.cust.[sub]prodid are null. The
data was strewn across multiple tables in MS SQL; we're normalizing it
into one, hence the need to populate the two columns independently.
/rls
--
Rosser Schwarz
Total Card, Inc
is nominally more than two orders of
mangitude performance improvement, versus several days.
Many thanks, Aaron.
/rls
--
Rosser Schwarz
Total Card, Inc.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
|
Indexes:
ix_debtid btree (debtid)
/rls
--
Rosser Schwarz
Total Card, Inc.
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
at the output of vacuum verbose, I
can't say whether that makes the cut for oodles. My suspicion is no.
/rls
--
Rosser Schwarz
Total Card, Inc.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send
--
Rosser Schwarz
Total Card, Inc.
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
times since then.
/rls
--
Rosser Schwarz
Total Card, Inc.
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
BLCKSZ, never built 7.3.anything at all. If 7.3 were installed, would
it have any problem reading a 7.4 cluster?
/rls
--
Rosser Schwarz
Total Card, Inc.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Greg Spiegelberg wrote:
I've been following this thread closely as I have the same problem
with an UPDATE. Everything is identical here right down to the
strace output.
Has anyone found a workaround or resolved the problem? If not,
I have test systems here which I can use to help up test
Greg Spiegelberg wrote:
Will advise.
After creating 100, 1K, 10K, 100K and 1M-row subsets of account.cust and
the corresponding rows/tables with foreign key constraints referring to
the table, I'm unable to reproduce the behavior at issue.
explain analyze looks like the following, showing the
dangerous.
/rls
--
Rosser Schwarz
Total Card, Inc.
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
to is never touched; they
should remain utterly ignorant of whatever happens to other
columns in the same row.
/rls
--
Rosser Schwarz
Total Card, Inc.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
--
Rosser Schwarz
Total Card, Inc.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
On Fri, 02 Jul 2004 20:50:26 +0200, Edoardo Ceccarelli [EMAIL PROTECTED] wrote:
This is the query:
select max(KA) from annuncio
wasn't supposed to do an index scan? it takes about 1sec to get the result.
TIP 5: Have you checked our extensive FAQ?
I believe this is a FAQ.
See:
while you weren't looking, Francisco Reyes wrote:
Is there any disadvantage of having the enable_seqscan off?
Plenty.
The planner will choose whichever plan looks cheapest, based on the
information it has available (table size, statistics, c). If a
sequential scan looks cheaper, and in your
while you weren't looking, Ray wrote:
CREATE INDEX idx_doc_substr_doc_urn ON doc USING btree (SUBSTR(doc_urn,10));
CREATE INDEX idx_doc_substr_doc_urn ON doc USING btree ((SUBSTR(doc_urn,10)));
You need an additional set of parens around the SUBSTR() call.
/rls
--
:wq
while you weren't looking, Gary Doades wrote:
The .NET Runtime will be a part of the next MS SQLServer engine.
It won't be long before someone writes a procedural language binding
to PostgreSQL for Parrot [1]. That should offer us a handful or six
more languages that can be used, including
while you weren't looking, Merlin Moncure wrote:
2 way or 4 way Opteron depending on needs (looking on a price for 4-way?
Go here: http://www.swt.com/qo3.html).
Try also the Appro 1U 4-way Opteron server, at:
http://www.appro.com/product/server_1142h.asp
I specced a 4-way 842 (1.6 GHz:
while you weren't looking, Greg Stark wrote:
Back in the day, we used to have problems with our 1U dual pentiums. We
attributed it to heat accelerating failure. I would fear four opterons in 1U
would be damned hard to cool effectively, no?
Opterons actually run pretty coolly, comparatively.
while you weren't looking, Matthew Nuzum wrote:
select accountid, min(atime) as atime, sessionid from usage_access
group by accountid,sessionid;
Try something along the lines of:
select ua.accountid
, (select atime
from usage_access
where sessionid = ua.sessionid
while you weren't looking, Kevin Brown wrote:
[reordering bursty reads]
In other words, it's a corner case that I strongly suspect
isn't typical in situations where SCSI has historically made a big
difference.
[...]
But I rather doubt that has to be a huge penalty, if any. When a
process
while you weren't looking, Derek Buttineau|Compu-SOLVE wrote:
I'm hoping this is the right place to send this.
The PostgreSQL Performance list, pgsql-performance@postgresql.org
would be more appropriate. I'm copying my followup there, as well.
As for your query, almost all the time is actually
On 8/24/05, Alexandre Barros [EMAIL PROTECTED] wrote:
i wouldn't be so stunned if the newer machine was ( say ) twice faster
than the older server, but over three times faster is disturbing.
RAID5 on so few spindles is a known losing case for PostgreSQL. You'd
be far, far better off doing a
On Mon, Jan 4, 2010 at 2:57 PM, Madison Kelly li...@alteeve.com wrote:
As for autovacuum, I assumed (yes, I know) that all v8.x releases enabled it
by default. How would I confirm that it's running or not?
I believe it's not enabled by default in 8.1-land, and is as of 8.2
and later. Whether
On Wed, May 5, 2010 at 10:17 PM, Neha Mehta neha.me...@lntinfotech.comwrote:
I am trying to have synchronous master-master replication in PostgreSQL8.4
using PgPool II. I am not able to configure PgPool on the system, it gives
me an error, libpq is not installed or libpq is old.
(FYI: This
On Fri, May 21, 2010 at 4:53 PM, Richard Yen d...@richyen.com wrote:
Any ideas why the query planner chooses a different query plan when using
prepared statements?
A prepared plan is the best one the planner can come up with *in
general* for the query in question. If the distribution of the
On Fri, Mar 4, 2011 at 10:34 AM, Glyn Astill glynast...@yahoo.co.uk wrote:
I'm wondering (and this may be a can of worms) what peoples opinions are on
these schedulers? I'm going to have to do some real world testing myself
with postgresql too, but initially was thinking of switching from
On Mon, Jan 30, 2012 at 9:46 AM, Saurabh saurabh@gmail.com wrote:
I can not create the index after insertion because user can
search the data as well while insertion.
Remember, DDL is transactional in PostgreSQL. In principle, you
should be able to drop the index, do your inserts, and
On Tue, May 15, 2012 at 8:21 AM, Віталій Тимчишин tiv...@gmail.com wrote:
We are using Areca controller with BBU. So as for me, question is: Can 520
series be set up to handle fsyncs correctly?
No.
The cause for capacitors on SSD logic boards is that fsyncs aren't
flushed to NAND media, and
On Tue, Dec 11, 2012 at 5:17 PM, Evgeny Shishkin itparan...@gmail.comwrote:
Actually most of low-end SSDs don't do write caching, they do not have
enough ram for that.
AIUI, *all* SSDs do write-caching of a sort: writes are actually flushed to
the NAND media by erasing, and then overwriting
On Mon, Jan 28, 2013 at 10:54 AM, Craig James cja...@emolecules.com wrote:
But if the drop-and-restore-trigger operation blocks all access to the
tables, that's a problem.
Were the triggers in question created with CREATE CONSTRAINT TRIGGER? If
not, ALTER TABLE foo DISABLE TRIGGER USER may
On Thu, Dec 5, 2013 at 9:55 PM, Skarsol skar...@gmail.com wrote:
The rule is being used to return the id of the insert...
Take a look at the RETURNING clause of the INSERT statement. That should
meet your needs here without having to bother with rules.
rls
--
:wq
32 matches
Mail list logo