This looks like the same optimizer problem that occasionally plagues our
customers. Whenever the estimated rows of a join==1, but the actual rows
is higher, the optimizer may choose very poor plans. I made some attempts
to fix. The very simple fix is to never estimate 1 for a join result.
Even
not disable hash aggregation on the slave as this might
have other consequences so this raises a number of questions. Firstly Is
there anything that I can do to stop this feature? Why is the slave
behaving differently to the master?
Thanks in advance for any help.
Cheers
Matthew
explain
This related to a post in the general bugs forum, but I found this forum,
and
this seems more appropriate. This is my second attempt to post, I believe
the first attempt last week did not work, apologies if I'm duplicating.
http://comments.gmane.org/gmane.comp.db.postgresql.bugs/39011
I made
to close the loop on this and to thank the
community again for their support.
Best,
Matt
From: Pavy Philippe [philippe.p...@worldline.com]
Sent: Tuesday, March 25, 2014 4:10 PM
To: Matthew Spilich; pgsql-performance@postgresql.org
Subject: RE: [PERFORM
Hi everyone!
I've been working on a puzzling issue for a few days am am hoping that someone
has seen something similar or can help. There have been some odd behaviors on
one of my production facing postgres servers.
version info from postgres: PostgreSQL 9.1.9 on x86_64-unknown-linux-gnu,
Hi everyone!
I've been working on a puzzling issue for a few days am am hoping that someone
has seen something similar or can help. There have been some odd behaviors on
one of my production facing postgres servers.
version info from postgres: PostgreSQL 9.1.9 on x86_64-unknown-linux-gnu,
To: Ray Stell; Matthew Spilich
Cc: pgsql-performance@postgresql.org
Subject: RE : [PERFORM] Stalls on PGSemaphoreLock
Hello
Recently I have a similar problem. The first symptom was a freeze of the
connection and 100% of CPU SYS during 2 et 10 minutes, 1 or 2 times per day.
Connection impossible
Tom Lane wrote:
(3) The performance of the truncation itself should not be viewed in
isolation; subsequent behavior also needs to be considered. An example
of possible degradation is that index bloat would no longer be
guaranteed to be cleaned up over a series of repeated truncations.
(You
(cost=50965693.08..51700624.28 rows=293972480 width=17)
Sort Key: public.tracker.objectid, public.tracker.fieldname
- Seq Scan on tracker
(cost=0.00..5310600.80 rows=293972480 width=17)
(8 rows)
Matthew
--
I quite understand I'm
that this is something that can be done in
the new Postgres 9, with a sorted group by - something like this:
SELECT group, LAST(value, ORDER BY number) FROM table GROUP BY group
Is this something that is already built in, or would I have to write my
own LAST aggregate function?
Matthew
table
I may be mistaken, but as I understand it, a windowing function doesn't
reduce the number of rows in the results?
Matthew
--
Don't worry about people stealing your ideas. If your ideas are any good,
you'll have to ram them down people's throats. -- Howard Aiken
--
Sent via pgsql
to a RAID6 set, then there is no
data loss.
Matthew
--
And the lexer will say Oh look, there's a null string. Oooh, there's
another. And another., and will fall over spectacularly when it realises
there are actually rather a lot.
- Computer Science Lecturer (edited)
--
Sent via pgsql
On Sun, 25 Jul 2010, Yeb Havinga wrote:
Graph of TPS at http://tinypic.com/r/b96aup/3 and latency at
http://tinypic.com/r/x5e846/3
Does your latency graph really have milliseconds as the y axis? If so,
this device is really slow - some requests have a latency of more than a
second!
Matthew
On Mon, 26 Jul 2010, Greg Smith wrote:
Matthew Wakeling wrote:
Does your latency graph really have milliseconds as the y axis? If so, this
device is really slow - some requests have a latency of more than a second!
Have you tried that yourself? If you generate one of those with standard
? It seems to work on a whole load of platforms.
Matthew
--
I would like to think that in this day and age people would know better than
to open executables in an e-mail. I'd also like to be able to flap my arms
and fly to the moon.-- Tim Mullen
--
Sent via
.
Matthew
--
Unfortunately, university regulations probably prohibit me from eating
small children in front of the lecture class.
-- Computer Science Lecturer
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your
suspect that collisions would be relatively infrequent compared to
some of the other locks we use. As noted in the email, it may
actually normally be an increment and test within an existing
locked block.
Fair enough. It may be much less of a problem than I had previously
thought.
Matthew
On Wed, 7 Jul 2010, JOUANIN Nicolas (44) wrote:
It seems to work fine (same execution plan and less duration) after :
- setting default_statistics_target to 100
- full vacuum with analyze
Don't do VACUUM FULL.
Matthew
--
I suppose some of you have done a Continuous Maths course. Yes
is weird.
at the most its not very popular.
It's not OpenVz that is wierd, but virtualisation in general. If you are
running in a virtual machine, then all sorts of things will not run as
well as expected.
Matthew
--
Contrary to popular belief, Unix is user friendly. It just happens to be
very
of comparators.
Matthew
--
For those of you who are into writing programs that are as obscure and
complicated as possible, there are opportunities for... real fun here
-- Computer Science Lecturer
--
Sent via pgsql-performance mailing list (pgsql-performance
queries, then increase the amount of RAM, as Kevin said, and see if you
can fit the active portion of the database into RAM.
Matthew
--
Nog: Look! They've made me into an ensign!
O'Brien: I didn't know things were going so badly.
Nog: Frightening, isn't it?
--
Sent via pgsql
.
Matthew
--
I don't want the truth. I want something I can tell parliament!
-- Rt. Hon. Jim Hacker MP
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
, and typical performance figures for a drive like that.
Matthew
--
Don't criticise a man until you have walked a mile in his shoes; and if
you do at least he will be a mile behind you and bare footed.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your
why you need a little
bit of non-volatile storage to mediate that to properly support barriers.
Of course, from a performance point of view, yes, you need some NVRAM on
any kind of spinning storage to maintain high commit rates.
Matthew
--
I wouldn't be so paranoid if you weren't all out
to be a large
burden on performance.
Matthew
--
Picard: I was just paid a visit from Q.
Riker: Q! Any idea what he's up to?
Picard: No. He said he wanted to be nice to me.
Riker: I'll alert the crew.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes
On Fri, 18 Jun 2010, Robert Haas wrote:
On Tue, Jun 15, 2010 at 8:23 AM, Matthew Wakeling matt...@flymine.org wrote:
Absolutely, and I said in
http://archives.postgresql.org/pgsql-performance/2010-03/msg00272.php
but applied to the Postgres B-tree indexes instead of heaps
.
Matthew
--
People who love sausages, respect the law, and work with IT standards
shouldn't watch any of them being made. -- Peter Gutmann
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
has not implemented this in any of its indexing
systems.
Matthew
--
An ant doesn't have a lot of processing power available to it. I'm not trying
to be speciesist - I wouldn't want to detract you from such a wonderful
creature, but, well, there isn't a lot
40 and 100 times faster than random pages, depending on the drive.
However, caches tend to favour index scans much more than sequential
scans, so using a value between 40 and 100 would discourage Postgres from
using indexes when they are really the most appropriate option.
Matthew
--
A. Top
) on each table.
random_page_cost=1
I agree with Tomas that this is rarely a useful setting.
Matthew
--
You can configure Windows, but don't ask me how. -- Bill Gates
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http
OK to not flush the
cache when that call comes in if my battery is working fine, that would
make this whole problem go away.
The only place this can be properly sorted is the RAID controller.
Anywhere else would be crazy.
Matthew
--
To err is human; to really louse things up requires root
single row in the table to return the matching rows, so a sequential scan,
filter, and sort would be much faster. Of course, if you had an index
capable of answering the WHERE clause, that would be even better for that
case.
Matthew
--
Don't criticise a man until you have walked a mile in his
regardless of barriers (although barriers may
make a small difference). If it does not, then it is likely that the fast
speed you are seeing with barriers off is unsafe.
There should be no just missed the sector going past for write problem
ever with a battery-backed cache.
Matthew
.
Matthew
--
Debugging is twice as hard as writing the code in the first place.
Therefore, if you write the code as cleverly as possible, you are, by
definition, not smart enough to debug it. - Kernighan
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make
CLUSTERing the tables on the
index.
Matthew
--
And the lexer will say Oh look, there's a null string. Oooh, there's
another. And another., and will fall over spectacularly when it realises
there are actually rather a lot.
- Computer Science Lecturer (edited)
--
Sent via pgsql-performance
a row to an array caused
the whole array to be copied, which put a bit of a damper on performance.
Matthew
--
The problem with defending the purity of the English language is that
English is about as pure as a cribhouse whore. We don't just borrow words;
on occasion, English has pursued other
On Tue, 1 Jun 2010, Stephen Frost wrote:
* Matthew Wakeling (matt...@flymine.org) wrote:
The major case I found when writing pl/pgsql was when trying to build
arrays row by row. AFAIK when I tried it, adding a row to an array caused
the whole array to be copied, which put a bit of a damper
, and
maybe even not do partitioning.
Matthew
--
Trying to write a program that can't be written is... well, it can be an
enormous amount of fun! -- Computer Science Lecturer
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your
, then
there is no representation for the 29th of February, so not all data
points will have a representative number to insert into the database.
Matthew
--
No, C++ isn't equal to D. 'C' is undeclared, so we assume it's an int,
with a default value of zero. Hence, C++ should really be called 1
as
if the values were available. The whole idea is to avoid the planning cost
each time the query is executed, but if your data is unusual it can
result in worse plans.
Matthew
--
Existence is a convenient concept to designate all of the files that an
executable program can potentially process
could create an index
on (extract(YEAR FROM m.taken)).
Matthew
--
Here we go - the Fairy Godmother redundancy proof.
-- Computer Science Lecturer
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your
be faster, but for 4046 it wouldn't.
If you will be querying by season quite regularly, had you considered
partitioning by season?
Matthew
--
Geography is going places.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http
are?
Matthew
--
Nog: Look! They've made me into an ensign!
O'Brien: I didn't know things were going so badly.
Nog: Frightening, isn't it?
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
weird. How is the cost of the merge join only 902, when the
cost of one of the branches 157830, when there is no LIMIT?
Are the statistics up to date?
Matthew
--
As you approach the airport, you see a sign saying Beware - low
flying airplanes. There's not a lot you can do about that. Take
your
of Postgres and makes use of materialised views to
speed up queries) uses a similar approach - it expends effort proportional
to the estimated cost of the query, as reported by EXPLAIN.
Matthew
--
To most people, solutions mean finding the answers. But to chemists,
solutions are things that are still
this: create index idx1 on tb1(col1, col2);
yup :)
For those of you who are not native English speakers, Yup is a synonym
for Yes.
Matthew
--
Richards' Laws of Data Security:
1. Don't buy a computer.
2. If you must buy a computer, don't turn it on.
--
Sent via pgsql-performance mailing list
On Tue, 30 Mar 2010, Faheem Mitha wrote:
work_mem = 1 GB (see diag.{tex/pdf}).
Sure, but define sane setting, please. I guess part of the point is that I'm
trying to keep memory low
You're trying to keep memory usage low, but you have work_mem set to 1GB?
Matthew
--
Prove to thyself
On Mon, 29 Mar 2010, randa...@bioinfo.wsu.edu wrote:
WHERE ... lower(n.name) LIKE 'Scaffold:scaffold_163:1000..1199%' ...
I'm sure you noticed that this is never going to return any rows?
Matthew
--
Me... a skeptic? I trust you have proof?
--
Sent via pgsql-performance mailing list (pgsql
space.
Matthew
--
If you let your happiness depend upon how somebody else feels about you,
now you have to control how somebody else feels about you. -- Abraham Hicks
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http
need and scaring you about wasting resources,
than it would cost to just slap 24GB in the machine.
24GB is the least amount of RAM I would consider putting in a new server
nowadays. It's so cheap.
Matthew
--
Lord grant me patience, and I want it NOW!
--
Sent via pgsql-performance mailing list
linked
messages is resolved. It depends.
Matthew
--
I've run DOOM more in the last few days than I have the last few
months. I just love debugging ;-) -- Linus Torvalds
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http
into the core gist code, but am rather daunted by
it. I believe that there is something there that is taking more time than
I can account for. The indexing algorithm itself is good.
Matthew
--
The problem with defending the purity of the English language is that
English is about as pure
the scope of the problem of speeding up gist.
Matthew
--
If you let your happiness depend upon how somebody else feels about you,
now you have to control how somebody else feels about you. -- Abraham Hicks
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes
-performance/2009-07/msg00348.php
It seems that getting pg_dump to do the compression is a fair amount
slower than piping the plain format dump straight through gzip. You get a
bit more parallelism that way too.
Matthew
--
I'm always interested when [cold callers] try to flog conservatories
are the implications of using TRUNCATE on a table that has TOASTed
data? Is TOAST all stored in one single table, or is it split up by owner
table/column name? Might you still end up with a normal delete operation
on the TOAST table when performing a TRUNCATE on the owner table?
Matthew
--
sed -e '/^[when
On Thu, 25 Feb 2010, Bruce Momjian wrote:
Was there every any conclusion on this issue?
Not really. Comments inline:
Matthew Wakeling wrote:
Revisiting the thread a month back or so, I'm still investigating
performance problems with GiST indexes in Postgres.
Looking at http
or SAS compatible, and they shouldn't be allowed to use those acronyms any
more.
Matthew
--
An optimist sees the glass as half full, a pessimist as half empty,
and an engineer as having redundant storage capacity.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org
speed of your WAL
discs is).
If you make sure of that, then there is no reason to get expensive fast
discs for the WAL at all (assuming they are expensive enough to not lie
about flushing writes properly).
Matthew
--
So, given 'D' is undeclared too, with a default of zero, C++ is equal to D
queries
running slowly, but have the danger of driving the system to swap and OOM.
Matthew
--
A good programmer is one who looks both ways before crossing a one-way street.
Considering the quality and quantity of one-way streets in Cambridge, it
should be no surprise that there are so many good
in the comments, I saw this: The slow times for Postgresql Bulk
Modify/Bulk Delete can be explained by foreign key references to the
updates table. I'm not sure that fully explains it though, unless there
are basically zero rows being deleted - it's hardly bulk then, is it?)
Matthew
--
People who love
.
Matthew
--
The early bird gets the worm, but the second mouse gets the cheese.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
On Wed, 27 Jan 2010, Віталій Тимчишин wrote:
How about SELECT SUM (case when id 120 and id 121 then 1 end)
from tbl_tracker;
That is very interesting.
* All the functions should be noop for null input
Alas, not true for COUNT(*), AVG(), etc.
Matthew
--
An optimist sees
without some very clever software
(because not all the data is available on the server), which will probably
be hard to manage and slow down the execution anyway.
My recommendation would be to stick with a single table unless you have a
real need to partition.
Matthew
--
Note: some countries
consuming that
much of their bandwidth, or even if there are copyright issues involved in
grabbing that much of their data?
(The other problem with using the word crore is that although it may
mean 1000 in a few countries, it could also mean 50.)
Matthew
--
Of course it's your fault
.
In my mind, this is quite a lot of work for the planner to do to solve
this one. That translates into quite a lot of work for some poor
programmer to do to achieve it. If you have the money, then hire someone
to do it!
Matthew
--
I don't want the truth. I want something I can tell parliament
.
Matthew
--
I wouldn't be so paranoid if you weren't all out to get me!!
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
=1234 ) ORDER BY orig_salary DESC
as there is going to be only two values for orig_salary.
Matthew
--
The early bird gets the worm. If you want something else for breakfast, get
up later.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your
is.
Matthew
--
The third years are wandering about all worried at the moment because they
have to hand in their final projects. Please be sympathetic to them, say
things like ha-ha-ha, but in a sympathetic tone of voice
-- Computer Science Lecturer
--
Sent
somewhere.
Matthew
--
A good programmer is one who looks both ways before crossing a one-way street.
Considering the quality and quantity of one-way streets in Cambridge, it
should be no surprise that there are so many good programmers there.
--
Sent via pgsql-performance mailing list (pgsql
. Someone mentioned something about banning the guy who set
the list up from the internet or something.
http://archives.postgresql.org/pgsql-performance/2008-01/msg00290.php
Matthew
--
Bashir: The point is, if you lie all the time, nobody will believe you, even
when you're telling
, then it starts being an issue.
Matthew
--
For every complex problem, there is a solution that is simple, neat, and wrong.
-- H. L. Mencken
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your
though.
It seems to me that CFQ is simply bandwidth limited by the extra
processing it has to perform.
Matthew
--
Experience is what allows you to recognise a mistake the second time you
make it.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes
confirm this?
Matthew
--
Let's say I go into a field and I hear baa baa baa. Now, how do I work
out whether that was baa followed by baa baa, or if it was baa baa
followed by baa?
- Computer Science Lecturer
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org
, but you could consider whether
it is sufficient to just have a spare disc sitting on a shelf next to the
server rather than using up a slot in the server. Depends on how quickly
you can get to the server on failure, and how important the data is.
Matthew
--
In the beginning was the word
, and looking at
how busy the CPU on the machine is. The disc may be the bottleneck, or the
CPU may be the bottleneck.
Matthew
--
Take care that thou useth the proper method when thou taketh the measure of
high-voltage circuits so that thou doth not incinerate both thee and the
meter; for verily
that it smooths random access, but it also accelerates fsync. The
whole point of the WAL disc is for it to be able to accept lots of fsyncs
very quickly, and it can't do that without its BBU cache.
Matthew
--
Heat is work, and work's a curse. All the heat in the universe, it's
going to cool down, because
the best strategy for a good RAID controller was NOOP.
Agreed. That's what we use here. My observation is though that noop is
identical in performance to anticipatory and deadline. Theoretically, it
should be faster.
Matthew
--
Take care that thou useth the proper method when thou taketh
the
disc head from one part of the disc to another.
Matthew
--
No trees were killed in the sending of this message. However a large
number of electrons were terribly inconvenienced.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription
lvm.
This is an FAQ. Counting the rows in a table is an expensive operation in
Postgres. It can't be answered directly from an index. If you want, you
can keep track of the number of rows yourself with triggers, but beware
that this will slow down write access to the table.
Matthew
--
Nog
.
Matthew
--
Me... a skeptic? I trust you have proof?
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
.
To be honest, that's always a good idea, although you didn't actually do
wrong. I do know people whose spam filters immediately discard emails that
contain a HTML alternative - that's taking it to the extreme!
Matthew
--
Beware of bugs in the above code; I have only proved it correct, not
tried
,
by maybe an order of magnitude, depending on your hardware setup.
The index scan may perform better at the moment, but the bitmap index scan
is safer.
Matthew
--
Change is inevitable, except from vending machines.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org
quickly, but it will allow you to see whether the
performance benefit is worth it. It will also tell you how long a cluster
will actually take, without actually locking anything.
Matthew
--
In the beginning was the word, and the word was unsigned,
and the main() {} was without form and void
will help more than
partitioning will.
Partitioning will help most in the case where you want to summarise a
single year's data. Not really otherwise.
Matthew
--
Q: What's the difference between ignorance and apathy?
A: I don't know, and I don't care.
--
Sent via pgsql-performance mailing
or
authentication purposes.
Matthew
--
To err is human; to really louse things up requires root
privileges. -- Alexander Pope, slightly paraphrased
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http
and keeping everything in cache.
Matthew
--
A good programmer is one who looks both ways before crossing a one-way street.
Considering the quality and quantity of one-way streets in Cambridge, it
should be no surprise that there are so many good programmers there.
--
Sent via pgsql-performance
, just in case you're asking for help about
managing the mailing list. The default behaviour is not to inform you that
it has done so. It is highly annoying - could a list admin please consider
changing this?
Matthew
--
I would like to think that in this day and age people would know better
rather than GROUP BY and seeing if that helps.
Matthew
--
Now the reason people powdered their faces back then was to change the values
s and n in this equation here. - Computer science lecturer
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make
.
Matthew
--
Now, you would have thought these coefficients would be integers, given that
we're working out integer results. Using a fraction would seem really
stupid. Well, I'm quite willing to be stupid here - in fact, I'm going to
use complex numbers.-- Computer Science
optimise the query?
But perhaps the biggest factor here is calling a five table join a pretty
simple query.
Matthew
--
Prolog doesn't have enough parentheses. -- Computer Science Lecturer
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your
).
Matthew
--
for a in past present future; do
for b in clients employers associates relatives neighbours pets; do
echo The opinions here in no way reflect the opinions of my $a $b.
done; done
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your
On Tue, 24 Nov 2009, Denis Lussier wrote:
Bouncing the app will roll back the transactions.
Depends on the application. Some certainly use a shutdown hook to flush
data out to a database cleanly.
Obviously if you kill -9 it, then all bets are off.
Matthew
--
Software suppliers are trying
in exceptional
circumstances, then cluster is the tool for the job.
Matthew
--
Matthew: That's one of things about Cambridge - all the roads keep changing
names as you walk along them, like Hills Road in particular.
Sagar: Yes, Sidney Street is a bit like that too.
Matthew: Sidney
and thoroughly confuse the client
application, you can send a TERM signal to a backend, but the consequences
to your data are on your own head.
Fix the application, don't tell Postgres to stop being a decent database.
Matthew
--
I would like to think that in this day and age people would know better than
is the priority, but I
would be very cautious about killing transactions in production. You don't
know what data is uncommitted. The safest thing to do may be to bounce the
application, rather than Postgres.
Matthew
--
All of this sounds mildly turgid and messy and confusing... but what the
heck
it is a turkey or a star?
Another possibility is a 3-ware card of some description.
Thanks in advance,
Matthew
--
Now you see why I said that the first seven minutes of this section will have
you looking for the nearest brick wall to beat your head against. This is
why I do it at the end
* creating the index and clustering, or before?
Matthew
--
[About NP-completeness] These are the problems that make efficient use of
the Fairy Godmother.-- Computer Science Lecturer
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your
command, then running vacuum full will make the
table and index layout worse, not better.
Matthew
--
Riker: Our memory pathways have become accustomed to your sensory input.
Data: I understand - I'm fond of you too, Commander. And you too Counsellor
--
Sent via pgsql-performance mailing list
around for 17 years or so in
http://portal.acm.org/citation.cfm?id=146943dl= so there really isn't any
excuse for modern flash drives not giving really fast small writes.
Matthew
--
for a in past present future; do
for b in clients employers associates relatives neighbours pets; do
echo
, and postgres is able to process it eight times
*faster*. Restarting Postgres kills the cache and puts you back at square
one.
Which of these is it?
Matthew
--
Reality is that which, when you stop believing in it, doesn't go away.
-- Philip K. Dick
1 - 100 of 567 matches
Mail list logo