table had not shown up on a query of age(relfrozenxid) WHERE
relkind='r' but the toast table showed up on a similar query with WHERE
relkind='t'.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast
multibyte charsets.
The %_ case is also trivially handled in UTF8 by simply ensuring that
_ doesn't match a non-initial octet. This allows % to advance by bytes
without danger of losing sync.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
as a klugy
way of saying I'm going to use listen() on this socket after the bind.)
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
wakeups in FreeBSD-6.x and earlier is the
entire semaphore set, not just one specific semaphore within the set. I
explained that to Kris some weeks ago, and someone (mux) did a patch (to
FreeBSD, not pg) which was already mentioned in this discussion.
--
Andrew, Supernews
http://www.supernews.com
to the local client_encoding per conversion_procs.
Thinking about this made me realize that there's another, ahem, elephant
in the room here: convert().
By definition convert() returns text strings which are not valid in the
server encoding. How can this be addressed?
--
Andrew, Supernews
http
On 2007-04-05, Tatsuo Ishii [EMAIL PROTECTED] wrote:
Andrew - Supernews [EMAIL PROTECTED] writes:
Thinking about this made me realize that there's another, ahem, elephant
in the room here: convert().
By definition convert() returns text strings which are not valid in the
server encoding
in various encodings, of which the
three-byte sequence 0xE2 0x82 0xAC is the one used in UTF-8.
Functions like chr() and ascii() should be dealing with the _number_ of the
code point, not with its representation in transfer encodings.
--
Andrew, Supernews
http://www.supernews.com - individual
as bytes is wrong too - it should correspond to
whatever the natural character numbering for the encoding is; for utf8
that is the Unicode code point.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast
in this regard?
The chr() function returns an octet, rather than a character; this is clearly
wrong and needs fixing.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)---
TIP 7: You can help support
/catalog/heap.c.
You've still got the usage of the relation OID and the relation _type_ OID
reversed.
The array element type that you pass to TypeCreate must be the _type_ OID.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end
character (and likewise for longer characters).
(And while I haven't tested it, it looks like the patch posted doesn't
account properly for the use of _, so it needs a bit more work.)
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end
. Treating UTF8 like any other multibyte charset and
converting everything to wide-chars is, in my opinion, always going to
result in suboptimal performance.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast
I think you've mis-analyzed the problem. That's especially true since
you are claiming that the existing code is already buggy when in fact no
such bugs have been reported (and clearly intarray has been running with
toasted array values for years).
--
Andrew, Supernews
http://www.supernews.com
On 2007-03-04, William ZHANG [EMAIL PROTECTED] wrote:
Here is the steps to reproduce it in CVS HEAD:
backend select -1 !=-1;
This arguably isn't a bug, because != is not a standard SQL operator, and
therefore !=- can legitimately be defined as a single operator by the user.
--
Andrew
that, at least prior to your patch,
values in index tuples could never be toasted?
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On 2007-03-02, Tom Lane [EMAIL PROTECTED] wrote:
Andrew - Supernews [EMAIL PROTECTED] writes:
On 2007-03-02, Gregory Stark [EMAIL PROTECTED] wrote:
I think these are actual bugs. If you happened to provide a large enough
datum
to the gist code it would cause the same problem I'm seeing
is because I haven't had a chance to test for regressions on 8.1.
--
Andrew, Supernews
http://www.supernews.com
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
On 2006-12-13, Simon Riggs [EMAIL PROTECTED] wrote:
On Wed, 2006-12-13 at 19:28 +, Simon Riggs wrote:
On Wed, 2006-12-13 at 04:23 +, Andrew - Supernews wrote:
While testing a PITR recovery, I discovered that recovery.conf doesn't
seem to allow specifying ' in the command string
. archive_command = '/path/to/script \'%f\' \'%p\'').
Should this be fixed?
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http
is of course the same sortops as for regular =).
The LTCMP and GTCMP operators imply a unique join operator due to
trichotomy, but this is not true for the sortops. While the above is
a bit contrived, I think non-contrived examples could be found too.
--
Andrew, Supernews
http://www.supernews.com
On 2006-12-13, Tom Lane [EMAIL PROTECTED] wrote:
Andrew - Supernews [EMAIL PROTECTED] writes:
On 2006-12-13, Tom Lane [EMAIL PROTECTED] wrote:
BTW, I think it's possible to prove that there need never be two for the
case of both sides the same datatype.
Counterexample even for a single data
on a row, do I have two copies of big_text TOASTED
or are they shared?
Shared.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)---
TIP 5: don't forget to increase your free space map
On 2006-09-23, Tom Lane [EMAIL PROTECTED] wrote:
Andrew - Supernews [EMAIL PROTECTED] writes:
Whether the underlying device lies about the write completion is another
matter. All current SCSI disks have WCE enabled by default, which means
that they will lie about write completion if FUA
will disable WCE permanently on a SCSI drive:
echo 'WCE: 0' | camcontrol modepage daXX -m 8 -P3 -e
(use -P0 to disable it only temporarily, or you can use just the second of
those commands alone to interactively edit the mode page)
--
Andrew, Supernews
http://www.supernews.com - individual and corporate
) that no-one else is using the same
MAC address. Anyone with substantial experience in networking will tell
you that the supposed uniqueness of manufacturer-assigned MACs is often
a myth, with (in extreme cases) entire batches of NICs being manufactured
with the same assigned MAC.
--
Andrew, Supernews
setup which doesn't bother to even install the file
anywhere) is to provide an answer to the question what timezone(s) are
applicable to a specific country. For that purpose aliases are irrelevent.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
On 2006-09-18, James William Pye [EMAIL PROTECTED] wrote:
FWIW, I'm +1 on the cleaner design you suggested. While I understand the
concerns of adding features/API this late;
Adding features is one thing, breaking existing users of the code is another.
--
Andrew, Supernews
http
output and numeric output is
measured in multiples, not in percentages.)
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire
plans for later commands in the transaction.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail
On 2006-09-15, D'Arcy J.M. Cain darcy@druid.net wrote:
On Fri, 15 Sep 2006 10:17:55 -
Andrew - Supernews [EMAIL PROTECTED] wrote:
Presumably the same speed as bigint, which is to say that while it is
faster than numeric for calculation, it is (much) slower for input/output
it is a constant, and therefore handled during planning)
select 0::numeric from generate_series(1,1000) s1,
generate_series(1,1000) s2;
This calls numeric_out(0) a million times. And so on.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
On 2006-09-15, Alvaro Herrera [EMAIL PROTECTED] wrote:
Andrew - Supernews wrote:
Numbers from an actual benchmark:
int4out(0) - 0.42us/call
numeric_out(0) - 0.32us/call
int4out(10) - 0.67us/call
numeric_out(10) - 0.42us/call
Is this really int4out
.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
for it to take more than 87 bytes.
Are you sure? Perhaps you are assuming that a char(1) field can be made
to be fixed-length; this is not the case (consider utf-8 for example).
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end
it should be pg_timezoneabbrevs? Or
more readably, perhaps pg_timezone_abbrevs, with pg_timezone_names for
the other view.
Yes, the abbreviations table is definitely misnamed.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end
of what to expose in the way of lock
identifier options. What we've got now is two int4's or an OID
which seems a bit random, not to mention that the key space overlaps
in an undocumented fashion.
It is documented in the original README.user_locks.
--
Andrew, Supernews
http://www.supernews.com
On 2006-09-05, Merlin Moncure [EMAIL PROTECTED] wrote:
On 9/5/06, Andrew - Supernews [EMAIL PROTECTED] wrote:
On 2006-09-05, Josh Berkus josh@agliodbs.com wrote:
The current code is GPL. It *has* to be removed.
Which is why Abhijit's version exists - it's intended to be a drop-in,
BSD
and implement them.
So you're prepared to violate the feature freeze to stick in a new API
that nobody currently wants to _use_, while forcing existing users to
resort to pgfoundry for a module that's been around for several major
releases?
--
Andrew, Supernews
http://www.supernews.com
and a half or so ago). However, others seemed to disagree, which is
why we now have a replacement version.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)---
TIP 4: Have you searched our
closely and being
in use in one existing core type.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)---
TIP 6: explain analyze is your friend
that was
equivalent to that of a non-parameterized query.
This would hopefully remove all cases where it is currently necessary to
use PQexec rather than PQexecParams, such as where parameterized limits,
immutable functions of parameters, partial indexes etc. are involved.
--
Andrew, Supernews
to turn that into a patch against the core...
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan
is the default
RI triggers.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command
be trichotomous, that is the possible results
are equal, greater, and less. There is no other not equal result.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)---
TIP 5: don't forget
functionality that is not already part of
Postgres itself.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On 2006-04-11, Richard Huxton dev@archonet.com wrote:
Andrew - Supernews wrote:
On 2006-04-11, Tom Lane [EMAIL PROTECTED] wrote:
I don't feel a need to offer specific examples as requested by Andrew.
Why not? You're basing your entire argument on a false premise (that
pl/pgsql is more
is not the way to go unnoticed.)
Doing something compute-intensive with pl/pgsql functions will be just as
noticable.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)---
TIP 1: if posting
-force password crack (try it! should only take an hour or
two) using the simple alpha(n) function example from my other post:
select a||b||c from alpha(3) s1(a), alpha(3) s2(b), alpha(2) s3(c)
where md5(a||b||c||'andrew') = 'ff113aee991f0a3519c3d4f97414561a'
limit 1;
--
Andrew, Supernews
http
.
And it was duly debunked.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
On 2006-04-11, Tom Lane [EMAIL PROTECTED] wrote:
Andrew - Supernews [EMAIL PROTECTED] writes:
On 2006-04-10, Bruce Momjian pgman@candle.pha.pa.us wrote:
[ security ]
It actually is the reason I have heard.
And it was duly debunked.
That is the reasoning, and personally I agree
On 2006-03-02, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
No. Here is the offending SP:
CREATE OR REPLACE FUNCTION update_my_cache() RETURNS void AS '
BEGIN
TRUNCATE TABLE my_cache_table;
TRUNCATE is another command that takes an access exclusive lock.
--
Andrew, Supernews
http
SP, not just during the execution of the
TRUNCATE command. Shouldn't TRUNCATE be releasing the lock as soon as
it finishes?
No, locks are always held until the end of the transaction.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
to the table since it is going to delete old tuples that might
otherwise still be visible to other transactions. DELETE on the other hand
simply marks the old tuples as dead; remember to vacuum as needed to clean
up.)
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP
. Otherwise, the string value of FS shall be considered to be an
extended regular expression. Each occurrence of a sequence
matching the extended regular expression shall delimit fields.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
of conflicts with user-defined names.
Does newsysviews already do this?
The current version in pgfoundry CVS uses pg_sysviews as the schema name.
If you have any better suggestions for the name, or any other aspect of the
project, then we're all ears.
--
Andrew, Supernews
http://www.supernews.com
to get
malformed sequences into the backend (which itself is far too lax
about parsing them).
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please
On 2006-02-20, Tatsuo Ishii [EMAIL PROTECTED] wrote:
In further investigation, Akio Ishida found this kind of attack is
possible even with EUC_JP/UTF-8.
How?
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast
with the fact that it's not pg_authid which is being
accessed, but rather the view pg_roles.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)---
TIP 5: don't forget to increase your free
is a total nonsense on the modern, CIDR, internet! The C in CIDR even
stands for Classless, so how can you ever justify introducing _new_,
non-traditional, dependencies on the traditional classes?
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
On 2006-01-25, Bruce Momjian pgman@candle.pha.pa.us wrote:
Andrew - Supernews wrote:
Having the behaviour be dependent on which part of the IP space is used
is a total nonsense on the modern, CIDR, internet! The C in CIDR even
stands for Classless, so how can you ever justify introducing _new_
are going
to accept the abbreviated forms at all.
(FWIW, ip4r at this time does not even accept '10.1/16', it insists on
'10.1.0.0/16'.)
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast
that for ip4-only apps, that's why pgfoundry.org/projects/ip4r
exists. It is possible that ip4r will be extended to ipv6 addresses, but
most unlikely that it will ever implement the overloaded inet semantics.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
by inet_aton().
The spec is quite explicit that inet_pton is not expected to accept the
abbreviated forms or any non-decimal values.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)---
TIP 6
comparison
operators, relying on the implicit cast from varchar to text to make this
transparent to users.
Well, inet/cidr have far more justification for being separate types than
text/varchar do - the text/varchar issue causes a great deal of confusion.
--
Andrew, Supernews
http
in questions asked on the IRC channel), and the problem can't be
worked around at the application level without knowing the value of
MAX_RANDOM_VALUE in order to correct the range to [0.0,1.0).
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
for sorting to even work, and such an ordering is completely determined by
either one of its greater-than/less-than operators?
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)---
TIP 5: don't
',2)
('Foo',3)
would produce the wrong output, no?
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
for sorting
purposes. (The requirement that constitute a strict weak ordering is
enough to ensure that this is an equivalence relation, and therefore
transitive; if does not meet this requirement then sorting may give wrong
answers, loop forever, or possibly crash.)
--
Andrew, Supernews
http
) on each of them once
one is dumped, i.e., sequentially?
pg_dump obtains an ACCESS SHARE lock on _every_ table it dumps, including
the inherited child tables individually, _before_ it starts dumping anything.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
-length; some characters require 4 bytes, not 2.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs
lock.
Otherwise AccessShare locks could starve the exclusive lock forever.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire
that
explicitly, themselves).
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On 2005-10-27, Paul Lindner [EMAIL PROTECTED] wrote:
On Mon, Oct 24, 2005 at 05:07:40AM -, Andrew - Supernews wrote:
I'm inclined to suspect that the whole sequence c1 f9 d4 c2 d0 c7 d2 b9
was never actually a valid utf-8 string, and that the d2 b9 is only valid
by coincidence (it's
On 2005-10-26, Tom Lane [EMAIL PROTECTED] wrote:
Andrew - Supernews [EMAIL PROTECTED] writes:
On 2005-10-26, Tom Lane [EMAIL PROTECTED] wrote:
Uh, no ... the global setting of add_missing_from does *not* tell you
anything about whether there exist views in the database that were
created under
On 2005-10-26, Tom Lane [EMAIL PROTECTED] wrote:
Andrew - Supernews [EMAIL PROTECTED] writes:
On 2005-10-26, Tom Lane [EMAIL PROTECTED] wrote:
Pretending it's the user's mistake isn't
an answer that fits down my craw very well...
I'm not claiming it's the user's mistake. My point
8.1... and ensure that dumps
from an 8.1 server include the explicit table names...
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner
On 2005-10-26, Tom Lane [EMAIL PROTECTED] wrote:
Andrew - Supernews [EMAIL PROTECTED] writes:
Wild idea: how about having pg_dump include SET add_missing_from = true;
in the dump file if, and only if, it is set that way in the server?
Uh, no ... the global setting of add_missing_from does
the full set of characters
accepted by the 8.0 Unicode sanity code?
No. 8.0 and before accepted a lot of stuff that it should never have, and
failed to accept stuff that it should have.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
c6 a4 was probably never valid;
c6 a4 also isn't a character you'd expect to find in common use.
My guess is that this was data in some non-utf-8 charset that managed to
get past the defective checks in 8.0.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
likely the interface he's using is assuming lo_* style blobs, rather
than bytea.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore
be called from a signal handler if
you _know_ that the signal did not interrupt any non-signal-safe function.
(Nor can the signal handler longjmp out in such a case, unless the code is
never again going to call any unsafe function.)
--
Andrew, Supernews
http://www.supernews.com - individual
On 2005-10-12, Andrew - Supernews [EMAIL PROTECTED] wrote:
On 2005-10-12, Tom Lane [EMAIL PROTECTED] wrote:
Andrew - Supernews [EMAIL PROTECTED] writes:
As the number of items in the IN clause increases, the planning time grows
rather radically.
I was looking at this yesterday
to use,
the only way to get useful performance for IN queries with more than a
handful of literal values is to use an array method, in spite of the fact
that the bitmap-OR execution plan is actually at least as fast.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP
On 2005-10-12, Tom Lane [EMAIL PROTECTED] wrote:
Andrew - Supernews [EMAIL PROTECTED] writes:
As the number of items in the IN clause increases, the planning time grows
rather radically.
I was looking at this yesterday. There is some O(N^2) behavior in
create_bitmap_subplan, stemming from
On 2005-09-08, Peter Eisentraut [EMAIL PROTECTED] wrote:
Andrew - Supernews wrote:
On 2005-09-08, Peter Eisentraut [EMAIL PROTECTED] wrote:
Andrew - Supernews wrote:
Running initdb behind the scenes is a proven dangerous practice
Please elaborate.
Example instance:
http
, not add them.
Running initdb behind the scenes is a proven dangerous practice; why
encourage it?
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)---
TIP 9: In versions below 8.0
On 2005-09-08, Peter Eisentraut [EMAIL PROTECTED] wrote:
Andrew - Supernews wrote:
Running initdb behind the scenes is a proven dangerous practice
Please elaborate.
Example instance:
http://archives.postgresql.org/pgsql-hackers/2004-12/msg00851.php
More generally, you risk running initdb
: Increment returns a network (192.168.0.0/24) rather than a host
While I suspect I know where this idea came from, it is equally boneheaded
since it is making completely unwarranted assumptions about how inet
values are being used.
--
Andrew, Supernews
http://www.supernews.com - individual
On 2005-09-01, Tom Lane [EMAIL PROTECTED] wrote:
Andrew - Supernews [EMAIL PROTECTED] writes:
On 2005-09-01, Tom Lane [EMAIL PROTECTED] wrote:
There's considerable feeling that that TODO item is bogus anyway.
The issue that I've seen is that currently, allowing non-superusers to
create
On 2005-09-01, Tom Lane [EMAIL PROTECTED] wrote:
Andrew - Supernews [EMAIL PROTECTED] writes:
On 2005-09-01, Tom Lane [EMAIL PROTECTED] wrote:
There is some merit in the thought that the DB owner should be able to
grant and revoke access on the public schema, but that no longer
requires
On 2005-09-01, Tom Lane [EMAIL PROTECTED] wrote:
Andrew - Supernews [EMAIL PROTECTED] writes:
On 2005-09-01, Tom Lane [EMAIL PROTECTED] wrote:
Change the ownership of public in template1 to be a dbadmin group.
Grant membership in dbadmin to all the DB owners. End of problem.
Only if all db
in the first place) or that you require
superuser intervention to modify pg_hba for each database created.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
in the query
snapshot.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)---
TIP 6: explain analyze is your friend
can't prevent xid wrap in his database regardless of how
often he vacuums it.)
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
. The exception is that you are forced to run a database-wide
VACUUM once in a while (every billion-and-so), but this will hopefully
disappear in 8.2 too,
Wishful thinking, or do you have a concrete plan to achieve it?
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP
a scalar type; it's permitted to
be a structure. The only valid operations on pthread_t values are assignment
and passing to functions (including pthread_equal() for equality comparison).
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
shared_buffers should be increased to
account for this fact.
Am I missing something?
O_DIRECT should only be being used for the WAL, not for buffer I/O.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast
On 2005-08-10, Tom Lane [EMAIL PROTECTED] wrote:
Andrew - Supernews [EMAIL PROTECTED] writes:
If a SCSI drive reports write complete when it hasn't actually put the
bits on the platter yet, then it's simply broken.
I guess you haven't read the spec much, then.
[ shrug... ] I have seen
billion.
Don't forget TOAST tables, they use oids too.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http
by
default, fwiw.
Turning it off isn't quite the performance killer that it is on IDE, of
course, but it is there.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
---(end of broadcast)---
TIP 5: don't forget
1 - 100 of 163 matches
Mail list logo
