but that
might have annoying overhead if there's a branch before every pg_atomic_cas
call.
Perhaps a minimal thing to do would be to detect a mismatch on startup and log
a message about it.
--
Gregory Stark
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-bugs mailing list (pgsql-bugs
being able to use the index
until they commit (and you start a new transaction to run the query in).
Normally I would not recommend running nightly REINDEXes, though in this case
because you had done a massive UPDATE against the table it was probably
helpful.
--
Gregory Stark
EnterpriseDB
Tom Lane t...@sss.pgh.pa.us writes:
Gregory Stark st...@enterprisedb.com writes:
Marinos Yannikos m...@pobox.com writes:
I had a strange problem this morning - I started a long-running UPDATE on a
heavily indexed table with about 8m rows last night to test a trigger-based
queue (PgQ):
I
is 8.2.12.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's 24x7 Postgres support!
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
parameters did you call this
function with? What did you expect to happen? What actually happened?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's 24x7 Postgres support!
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make
not, though,
since we have no way to actually determine whether the user trigger didn't do
something else equivalent.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL
training!
--
Sent via pgsql-bugs
of those.
That said, the second option seems pretty trivial to implement. I think the
performance would be awful for a live database but for a read-only database it
might make more sense.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's Slony
the database
files )
Uhm, just to be sure. You did pg_start_backup() on the primary *before* you
started copying the data files across, right?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's On-Demand Production Tuning
--
Sent via pgsql-bugs
three
memory leaks fixed in bug-fix releases since 8.3.1 but none should be related
to VACUUM FULL.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's Slony Replication support!
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make
-standard.html
As soon as I point out an SQL standard that you DON'T follow I get a barrage
of weasel words and pathetic excuses.
Well then.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's 24x7 Postgres support!
--
Sent via pgsql-bugs mailing
that there is no query, because the bytes
arriving
are garbage. A human observer could make sense of it in some cases, but not
a computer in the general case.
How is that different from any other syntax error?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Get trained
in the field so
that's cold comfort these days.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL
training!
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription
yyy RENAME COLUMN col2 TO colB;
EOF
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's RemoteDBA services!
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
indexes exist?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL
training!
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
(indexId, indexIds)
{
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL
training!
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http
.
The commands you described should take the same length of time regardless of
the size of table and the memory settings are not relevant. I suspect you're
actually running some different commands?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's
Tom Lane [EMAIL PROTECTED] writes:
Gregory Stark [EMAIL PROTECTED] writes:
Tom Lane [EMAIL PROTECTED] writes:
... I'm not even sure how to fix it (the nasty case is
changing directions partway through the scan); let alone how to fix it in a
way that's obviously enough right to make me feel
Tom Lane [EMAIL PROTECTED] writes:
Gregory Stark [EMAIL PROTECTED] writes:
Tom Lane [EMAIL PROTECTED] writes:
Well, if you think it's easy, the best form of criticism is a patch.
The change-of-direction problem seems to me to be messy --- not
insoluble, but messy enough to need beta testing
repeatedly.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL
training!
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
Tom Lane [EMAIL PROTECTED] writes:
Gregory Stark [EMAIL PROTECTED] writes:
Hm, that has the nasty side effect that someone who uses SCROLL but doesn't
fetch backwards much or at all suddenly gets a much more expensive plan than
if they didn't.
Well, what are they using SCROLL
confusing too.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's On-Demand Production Tuning
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
signal handler.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's Slony Replication support!
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
() is called with SO_ERROR. SYN packets are tried only for the
default tcp timeout of 20 seconds.
Uhm, 20 seconds would be an unreasonably low default. I think the RFCs mandate
timeouts closer to the 4 minutes you describe.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me
column from your INSERT
statement. Just let the DEFAULT expression generate a value for you. Then you
can use curval('event_log_id_seq') to find out what value it generated.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's RemoteDBA services
to do that yourself? Or if it isn't
being done for us we could just put that encoding in the email headers.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's On-Demand Production Tuning
--
Sent via pgsql-bugs mailing list (pgsql-bugs
functions.
The default is `-ftrapping-math'.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's Slony Replication support!
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http
Blake Lovely [EMAIL PROTECTED] writes:
PostgreSQL version: 8.2
Operating system: Vista home premium
8.2 was not supported on Vista as it came out long before Vista did. Try 8.3.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's 24x7
quota or super user space reservation could take affect. Could you create
file as a postgres user on pgsql filesystem?
Also check df -i
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL
training
Sorry, this is the URL I meant to send:
http://www.mail-archive.com/[EMAIL PROTECTED]/msg19905.html
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's RemoteDBA services!
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org
if the answer is correct.
IIRC the question is What is six times eight
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's Slony Replication support!
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your
ON (a.num1=b.num1)
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's RemoteDBA services!
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Michael Fuhr [EMAIL PROTECTED] writes:
On Wed, Feb 20, 2008 at 12:21:03PM +0100, Francisco Olarte Sanz wrote:
On Wednesday 20 February 2008, Gregory Stark wrote:
Unless you need cryptographic security I would not suggest using MD5. MD5
is intentionally designed to take a substantial
. In this scenario that's probably not
a top threat. Conceivably someone could create a denial-of-service attack
slowing down your server by causing your indexes to become unbalanced. But it
would be fairly challenging to engineer.
--
Gregory Stark
EnterpriseDB http
Heikki Linnakangas [EMAIL PROTECTED] writes:
Heikki Linnakangas [EMAIL PROTECTED] writes:
Gregory Stark wrote:
Heikki Linnakangas [EMAIL PROTECTED] writes:
As others have pointed out, CREATE UNIQUE INDEX i ON ((md5(column)) is a
pretty
good work-around.
Unless you need cryptographic
something about that but there's
nothing like that now.
We have hash indexes too but in practice a btree over a hash seems to work
just as well or better.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's PostGIS support
issue.
The release notes for the 8.1.x bug-fix and security releases are at:
http://www.postgresql.org/docs/8.1/static/release.html#RELEASE-8-1-11
Click Next or scroll up to the list to get the previous releases.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about
Next or scroll up to the list to get the previous releases.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's RemoteDBA services!
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ
.
8.3 may actually fix it for you because if they're plpgsql functions then they
will replan any cached query plans.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's RemoteDBA services!
---(end of broadcast
or
not regardless of how you refer to it.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's Slony Replication support!
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Abhay Kumar [EMAIL PROTECTED] writes:
Hi,
I am installing the Postgis 2.2.1 on PostgreSQL.
I think you would be better off speaking to this mailing list:
http://postgis.refractions.net/mailman/listinfo/postgis-users
--
Gregory Stark
EnterpriseDB http
of converting the tid to a
point so I could refer to the block or offset. In 8.3 this looks like:
select ctid from foo where (ctid::text::point)[0] = 0;
But in 8.2 iirc you had to call the tid output function explicitly because
there was no cast to text.
--
Gregory Stark
EnterpriseDB http
? And what exactly does the trash
data look like?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's On-Demand Production Tuning
---(end of broadcast)---
TIP 5: don't forget to increase your free space map
where tt.a = (t1.a + t2.a)*2
)
What plan does MS-SQL use to complete this? I wonder whether it's producing
the same answer Postgres is.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's PostGIS support!
---(end
Scan
Postgres is doing something equivalent to the first plan.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL
training!
---(end of broadcast
are timezone
updates.
(And since 8.1.3 there were several crashing and data eating bugs fixed in
those bug-fix releases)
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's PostGIS support!
---(end of broadcast
that.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's PostGIS support!
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan
be harder to optimize the our
current COPY can be optimized.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's PostGIS support!
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL
for each of the records being
inserted. Incrementing sequences is pretty damn quick and I doubt it would
actually be a bottleneck.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's PostGIS support!
---(end of broadcast
doesn't
have unix bit per file the only way to satisfy the check would be to mount the
filesystem with the option to make every file in the filesystem have those
bits. Storing your keys on a usb stick (which usually use fat filesystems)
isn't really such a crazy idea either.
--
Gregory Stark
Tom Lane [EMAIL PROTECTED] writes:
Alvaro Herrera [EMAIL PROTECTED] writes:
Gregory Stark wrote:
Storing your keys on a usb stick (which usually use fat filesystems)
isn't really such a crazy idea either.
Storing a server SSL key on a USB stick is not crazy? I don't follow.
What use case
reasonably easily,
but changing the basic transaction abort method is right out.
I fear having a message saying ERROR This is not an error is going to get us
laughed at.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's RemoteDBA services
Alvaro Herrera [EMAIL PROTECTED] writes:
Bruce Momjian escribió:
Magnus Hagander wrote:
On Fri, Nov 30, 2007 at 10:13:53AM +, Gregory Stark wrote:
Mike C. [EMAIL PROTECTED] writes:
ERROR: canceling statement due to user request
CONTEXT: automatic analyze of table
: automatic analyze of table dbs.public.entity_event
This is intentional, though perhaps the wording is confusing. What impression
does the wording give you? Does it make you think something has gone wrong?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about
you'll get 0.5.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's RemoteDBA services!
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs
Tom Lane [EMAIL PROTECTED] writes:
It's been clear for quite awhile that a stats target of 10 is often
too low, but no one has done the legwork to establish what a more
reasonable tradeoff point would be.
Any ideas on what measurements would be interesting for this?
--
Gregory Stark
.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL
training!
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire
merge the two
columns. The resulting records would have two bid columns.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's On-Demand Production Tuning
---(end of broadcast)---
TIP 1: if posting/reading
Tom Lane [EMAIL PROTECTED] writes:
Gregory Stark [EMAIL PROTECTED] writes:
That does really suck. But I'm not sure what we can do about it. There's no
SQL which is entirely equivalent to the resulting view.
If we were to do anything about it, I think it would have to be to
forbid
to add it to /etc/locale.gen and rerun locale-gen)
Also, what does lower('úabcdú') return in that locale?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
strict about that.)
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
, writing past the end or beginning of the
allocated memory, etc. Any bug like this can cause random core dumps in malloc
or free later.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 2: Don't
can get by
defining the environment variable MALLOC_CHECK_ before starting your program.
In bash you can do this by running your program with something like:
MALLOC_CHECK_=3 ./myprogram
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end
the single
byte 146 isn't a valid UTF8 character.
In PostgreSQL 8.2 I don't think there's any function to generate an arbitrary
Unicode code point. You'll have to do that on the client end and encode it in
UTF8 before sending. In PostgreSQL 8.3 chr() will in fact be modified to do
this.
--
Gregory
works by shortening it
but the return doesn't work because it returns a pointer to the float and
claims it's a pointer to the float8.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 5: don't
a while back
and people thought it was pointless but I think the number of reports of
hardware and kernel bugs resulting in zeroed and corrupted pages has been
steadily going up. If not in total than as a percentage of the total problems.
--
Gregory Stark
EnterpriseDB http
of error instead of trying to find the transaction in the clog.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
as semantically insignificant, so they get removed before the
concatenation.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose
of the last x):
$ ls -ld /tmp
drwxrwxrwt 8 root root 12288 Aug 18 16:30 /tmp
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire
Tom Lane [EMAIL PROTECTED] writes:
Gregory Stark [EMAIL PROTECTED] writes:
The structure of your query is a whole series of left outer joins, the result
of which is then (inner) joined with one more table. The outer joins return a
whole lot of records but the inner join is only going to match
-++---
add_missing_from| off|
Automatically adds missing table references to FROM clauses.
...
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
to be to the correct array type with a
run-time error if the type doesn't match. Or it could use the VIAIO cast which
would work as long as the input format matched. So you could always cast to
text[] even if it was an integer[] or something else originally.
--
Gregory Stark
EnterpriseDB http
Decibel! [EMAIL PROTECTED] writes:
On Jul 31, 2007, at 11:55 PM, Gregory Stark wrote:
And what type would the result be?
ANYELEMENT? I know that'd still have to be casted to something normal
eventually; do we have support for that?
There isn't really any such thing. There isn't really any
be looking for a file
named 16384.N where N is which gigabyte chunk.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
need to get this to work. This is a TODO item but nobody has indicated
they wish to (or know how to) do it yet.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 4: Have you searched our list
, what do you get
if you do:
enable_seqscan = off;
select * from reference where id = 7;
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating
it was
related to some significant changes that were being made. Because of those
changes 8.3 behaves markedly different in this area:
postgres=# select xmin || 'x' from w limit 1;
?column?
--
1679x
(1 row)
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
= fdividend / fdivisor;
qdigit = (fquotient = 0.0) ? ((int) fquotient) :
(((int) fquotient) - 1);/* truncate towards -infinity */
div[qi] = qdigit;
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end
Tom Lane [EMAIL PROTECTED] writes:
Gregory Stark [EMAIL PROTECTED] writes:
The source of the problem is the floating point arithmetic which is used to
do
the individual steps in the long division.
I don't think so. The ultimate source of the problem is that div_var
can only report
problem that SELECT triggers have. How many rows should you
expect that subquery to insert, update, or delete if it's used in a join
clause? Or in the where clause of another insert/update/delete statement?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
80 matches
Mail list logo