Tom Lane [EMAIL PROTECTED] writes:
hword_asciipart
hword_part
hword_numpart
Out of curiosity would the foo in foo-bär or the foo-beta1 be a
hword_asciipart or a hword_part/hword_numpart?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
.
Also, not all reviewers are committers.
--
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
running them together which
was blocking you from running benchmarks on them.
The problem I ran into was that by the time I had them all wrapped up major
new commits to the CVS tree made it uninteresting to benchmark the snapshot I
had. Also I think a new version of HOT had been posted.
--
Gregory
test it conveniently. Plus Postgres currently is
bombing out with more than 45 clients anyways due to the handles issue that
others are looking into (hence finding this limitation).
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end
as simply as in latin languages.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
of the tsearch api itself should just be
left outside of core in a contrib module so they can be fiddled with in
subsequent releases.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 2: Don't 'kill -9
too. The downsides are that CLUSTER locks the table while it runs and
it requires enough space to store a whole second copy of the table and its
indexes.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast
on the beta
right now.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
for example?
You have to start up your psql or other client run SELECT pg_backend_pid();
and attach to that process in the debugger. It sounds like you've connected to
the postmaster which doesn't actually do any of the work, it just forks other
backends.
--
Gregory Stark
EnterpriseDB http
the
interfaces can be fully integrated into SQL. So whereas previously you
installed a contrib module for the whole tsearch2, now it's all integrated
except for a few oddball functions which you can still get by supplementing
the core tsearch with the contrib module.
--
Gregory Stark
Tom Lane [EMAIL PROTECTED] writes:
Gregory Stark [EMAIL PROTECTED] writes:
The two-argument form may not be actively broken but it sounds not very
integrated. Passing a string which is then planned as an SQL query is not
very
SQL-ish.
True. I'll bet you don't like ts_stat() either
implementing
yourself.
--
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
statements.
There's another cost associated with prepared transactions. If it's set to 0
then there's no real reason we need to wal log lock operations.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 1
breakage, just potential confusion.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL
timezone.
Does the database acquire new timezones for these counties with the rule for
when they changed?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 5: don't forget to increase your free space
it is a bit bleeding edge.
But as I understand it the utf8 decoding is all our code anyways so I can't
quite figure out how it could be glibc's fault.
Does anybody else see anything like this?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end
Gregory Stark [EMAIL PROTECTED] writes:
Something very strange is going on on my machine with UTF8:
postgres=# show server_encoding;
server_encoding
-
UTF8
(1 row)
Hm. Well this doesn't look right:
(gdb) p pg_wchar_table[PG_UTF8]
$9 = {mb2wchar_with_len = 0x8364cff
,
pg_johab_verifier, 3}, /* 38; PG_JOHAB */
{0, pg_sjis_mblen, pg_sjis_dsplen, pg_sjis_verifier, 2} /* 40;
PG_SHIFT_JIS_2004 */
};
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 9
Tom Lane [EMAIL PROTECTED] writes:
Gregory Stark [EMAIL PROTECTED] writes:
Something very strange is going on on my machine with UTF8:
Argh, I missed rearranging a couple of tables in the recent patch to fix
up the encoding IDs. Will fix.
Hm, now things work correctly within the server
Gregory Stark [EMAIL PROTECTED] writes:
Hm, now things work correctly within the server if I play with text data
generated with convert_from(). But I can't seem to send utf-8 text directly in
psql any more:
Ah, figured it out, nothing to do with the server. I didn't have the locale
set
, and index accesses.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so
it worthwhile.
I think we are pretty set on having the DSM for vacuuming purposes so you'll
also have to argue this approach will cover enough additional cases or be
better in some other way compared to using the DSM to be a win.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
these specific solutions.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 6: explain analyze is your friend
:
symbol lookup error:
/home/stark/src/local-HEAD/pgsql/src/test/regress/./tmp_check/install//usr/local/pgsql/bin/psql:
undefined symbol: pg_valid_server_encoding_id
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast
Peter Eisentraut [EMAIL PROTECTED] writes:
Am Freitag, 12. Oktober 2007 schrieb Gregory Stark:
. when creating a new database from a template the new locale and encoding
must be identical to the template database's encoding and locale. Unless
the template is template0 in which case we
available and
our, possibly slow, wrapper if not. If we ban direct use of strcoll and other
lc_collate sensitive functions in Postgres we could also remember the last
locale used and not do unnecessary setlocales so existing use cases aren't
slowed down at all.
--
Gregory Stark
EnterpriseDB
database
would be able to tell you exactly what you're doing wrong and what you have to
do to avoid the problem.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
don't agree with the system collations?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
relid someplace
which the plan invalldation code can check for it?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe
Gregory Stark [EMAIL PROTECTED] writes:
Tom Lane [EMAIL PROTECTED] writes:
(It might be interesting to make textin produce a packed result when
possible, just to see what breaks; but I would be afraid to try to do
that for production...)
Reassuringly all checks pass with a hack like
Gregory Stark [EMAIL PROTECTED] writes:
Alvaro Herrera [EMAIL PROTECTED] writes:
Hmm, it looks like the race condition Heikki mentioned is the culprit.
We need a way to stop future analyzes from starting. Back to the
drawing board ...
A crazy idea I just had -- what if you roll
that it represents changes due to the rules
changing.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
timezone the birth isn't going to move.
The use case for storing a local timestamp with a timezone attached is for
things like appointments. If the time zone rules change you would want the
appointment to move with them, not to stay at the same moment in time.
--
Gregory Stark
EnterpriseDB
multiple versions of Postgres.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so
and so
on. Until the interface is very stable being in contrib makes perfect sense.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
functions, i feel it would serve most of the
indexing requirements.
We already do this. c.f. IMMUTABLE at
http://www.postgresql.org/docs/8.2/interactive/xfunc-volatility.html
and
http://www.postgresql.org/docs/8.2/interactive/sql-createindex.html
--
Gregory Stark
EnterpriseDB http
the records being considered.
If you want something faster you need a solution which can use an index to
scan only the target record. There are ways of doing that but they require
some application knowledge.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
as part of
its DDL.
--
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 enough. I'm not sure every OS
implements them as specified though.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 6: explain analyze is your friend
?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Alvaro Herrera [EMAIL PROTECTED] writes:
Gregory Stark wrote:
Reading the commit message about the TZ encoding issue I'm curious why this
isn't a more widespread problem. How does gettext now what encoding we want
messages in? How do we prevent things like to_char(now(),'month') from
Alvaro Herrera [EMAIL PROTECTED] writes:
Gregory Stark wrote:
So does the _() macro automatically recode it to the current server encoding?
Well, I'm not sure if it's _(), elog() or what, but it does get recoded.
If I have a different client_encoding and get a NOTICE, then both the
server
_(Monday) instead. Except in my tests I don't get
any French dates even when the server is started in French mode. I think we
just don't have localizations for those strings yet.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast
such as typical web sites to run more efficiently and
with fewer connections might also help clarify the use case it helps.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 9: In versions below 8.0
?
--
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
other compilers would be a compiler bug
since it would be an incompatible ABI change. I find it hard to believe
intel's compiler would get the ia64 ABI wrong. And hard to believe nobody's
noticed an incompatible ABI from gcc-generated binaries.
--
Gregory Stark
EnterpriseDB http
on the lock for 1s it wakes up, finds that the holder it's
waiting on is an autovacuum process and cancels it instead of finding no
deadlock.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 7: You can
? That would
solve the problem for the narrow case of pg_restore.
In the long run we could think about exposing some kind of command for
pg_restore to use which would disable autovacuum from touching a table. (Or
take a session-level lock on the table -- shudder)
--
Gregory Stark
EnterpriseDB
for details.
STATEMENT: CREATE DATABASE contrib_regression TEMPLATE=template0
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http
Gregory Stark [EMAIL PROTECTED] writes:
dugong (icc on ia64) has been failing the contrib installcheck consistently
since 6 days ago with errors like:
ERROR: could not fsync segment 0 of relation 1663/40960/41403: No such file
or directory
I checked a cvs diff between the two timestamps
the datum pointer into a separate
local variable of that type to suppress the optimization.
Fascinating.
Why do you cast arguments to memcmp to char* ?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP
Tom Lane [EMAIL PROTECTED] writes:
Gregory Stark [EMAIL PROTECTED] writes:
Why do you cast arguments to memcmp to char* ?
Well, *I* haven't done it in a long time,
I'm referring to tuptoaster.c:488
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
the idea of keeping the VARHDRSZ/VARSHDRSZ offset in
the varlen header seem pretty silly; hindsight is 20/20 and all that.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 4: Have you searched our
Tom Lane [EMAIL PROTECTED] writes:
Gregory Stark [EMAIL PROTECTED] writes:
I'm wondering whether it doesn't make sense to lower VARATT_SHORT_MAX to 0x70
to allow for at least a small number of constant values which could indicate
some special type of datum. That could be used to indicate
Tom Lane [EMAIL PROTECTED] writes:
Gregory Stark [EMAIL PROTECTED] writes:
I'm wondering whether it doesn't make sense to lower VARATT_SHORT_MAX to 0x70
to allow for at least a small number of constant values which could indicate
some special type of datum. That could be used to indicate
that makes the macro
VARSIZE_EXTERNAL_EXHDR_EXHDR() :/ )
--
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 an index scan
a
loophole for anyone for whom the test didn't work properly.
That sounds like a good combination
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ
is that things like pgadmin can connect properly to
either 8.3, 8.2, and even 8.1 using the new libraries regardless of how the
server authentication is configured. Do they work correctly if the server
tries to do password authentication, ident, kerberos, etc.
--
Gregory Stark
EnterpriseDB http
they'll break if you swap the
shared library out from under them?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http
be building 7.2.8, an unsupported
release over two years and 5 major releases old?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 6: explain analyze is your friend
not much point in making an exception
for something which will only be really useful once further work is done in
the same area.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 2: Don't 'kill -9
table?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
32768 11691023
--
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 an index scan if your joining column's datatypes
(result), inputText, len);
+ SET_VARSIZE_SHORT(result, len+VARHDRSZ_SHORT);
+ PG_RETURN_TEXT_P(result);
+ }
+ #endif
+
result = (text *) palloc(len + VARHDRSZ);
SET_VARSIZE(result, len + VARHDRSZ);
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
of 1st digit */
uint16 n_sign_dscale; /* Sign + display scale */
+ int16 n_weight; /* Weight of 1st digit */
charn_data[1]; /* Digits (really array of
NumericDigit) */
} NumericData;
--
Gregory Stark
Tom Lane [EMAIL PROTECTED] writes:
Tom Lane [EMAIL PROTECTED] writes:
Gregory Stark [EMAIL PROTECTED] writes:
I think we also should move the NumericData and declaration to numeric.c and
make the Numeric type an opaque pointer for the rest of the source
tree.
I don't agree with that; we
Tom Lane [EMAIL PROTECTED] writes:
Gregory Stark [EMAIL PROTECTED] writes:
Ok, this removes what should be most if not all of the call sites where we're
detoasting text or byteas. In particular it gets all the regexp/like
functions
and all the trim/pad functions. It also gets hashtext
Tom Lane [EMAIL PROTECTED] writes:
Gregory Stark [EMAIL PROTECTED] writes:
(It might be interesting to make textin produce a packed result when
possible, just to see what breaks; but I would be afraid to try to do
that for production...)
This all brings up the question of what other files
minutes to do
that. I'm surprised it would have such a large effect though.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Guillaume Smet [EMAIL PROTECTED] writes:
Gregory,
On 9/21/07, Gregory Stark [EMAIL PROTECTED] wrote:
Hm, it does seem I missed like.c when I converted all the text operators to
avoid detoasting packed varlenas. I'll send a patch in a few minutes to do
that. I'm surprised it would have
))
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 6: explain analyze is your friend
Brendan Jurd [EMAIL PROTECTED] writes:
On 9/22/07, Gregory Stark [EMAIL PROTECTED] wrote:
The canonical way to do it is with
DatumGetCString(DirectFunctionCall1(textout, t))
Ah, I see. Thanks.
In that case, would it be helpful if I submitted a patch for the
various code fragments
copying it to new memory instead of memory which is almost
certainly likely in processor caches which would need to be invalidated would
actually be faster and avoiding the use of memmove could be faster too.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
to slip this into the upcoming 8.2.5?
I haven't been able to find anything which specifies precisely when it'll
happen though. Just knowing the week or even day isn't enough.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast
(windows,solaris,openbsd and
linux).
Is this exhaustive? That is, are we sure this never happened before Sept 11th?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 4: Have you searched our list
)
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
---End Message---
--
Gregory
won't worry.
I tend to agree with you. We should only use overloading when the function is
essentially the same just tweaked as appropriate for the datatype, not when
the meaning is different.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end
that.
No intervention is required for normal expression indexes using those
functions or hash indexes which will be rebuilt during a database upgrade
anyways. I don't think hash_any itself changed so this wouldn't affect
hashtext or any hash function which was already using hash_any.
--
Gregory Stark
data in a container format or something.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
/* exists in Solaris
headers */
+ #undef V_FALSE
+ #endif
/*
* output values for result output parameter of clean_fakeval_intree
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast
for their intended purpose of client-server
communication if they're not.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Tom Lane [EMAIL PROTECTED] writes:
It's a corner case, but I say it's a must-fix.
Of course
Those bug reports have been bothering me for most of a year ...
Are there any other outstanding reports like that?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
the user to do something?
--
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
for and tried a lot of different approaches to solve this problem.
This was the lowest impact solution and the only one that was convincingly
correct (imho).
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP
for this contraption before we had
plan invalidation, but what use is it now?
Argh, sorry, rereading your message I see there are a few details which I
missed which completely change the meaning of it. Ignore my previous mail :(
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Gregory Stark [EMAIL PROTECTED] writes:
Tom Lane [EMAIL PROTECTED] writes:
AFAICS, the whole indcreatexid and validForTxn business is a waste of
code. By the time CREATE INDEX CONCURRENTLY is ready to set indisvalid,
surely any transactions that could see the broken HOT chains are gone
.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
of
consisting of those three bytes described above?
--
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
than the build farm.
Especially when it comes to vacuum and vacuum full and cluster and so on given
that autovacuum barely has a chance to start looking at things before the
regression tests are done.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
is executed.
I'm a bit afraid the plan will stay cached longer than would be ideal. If the
plan doesn't use the new index then ideally we would want to invalidate it
from the cache at the end of this transaction I suppose.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
the sleep time. So it would always
process a full cycle for example but adjust the sleep time based on what
percentage of the cycle the backends used up in the last sleep time.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast
Hannu Krosing [EMAIL PROTECTED] writes:
Is this apoc9009 guy real ?
Please, just don't respond.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ
with a smaller scale factor?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 6: explain analyze is your friend
the percentages on the transactions. I think Stock
Level and Order Status are entirely read-only but I would have to check. Stock
Level is a very intensive query though so I wouldn't suggest raising the
percentage on that.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
any old tuples in broken chains
uses the serializable snapshot as a conservative proxy for the oldest snapshot
which might be in use. That will work for both serializable and read
committed.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end
for large I/O bound databases
That seems too vague for the TODO. Did you have specific items in mind?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 6: explain analyze is your friend
was
discussing PostgreSQL. So presumably he was speaking on behalf of the postgres
community.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
an
error if someone opens a file in read-only mode when they actually do
have write permission?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http
Tom Lane [EMAIL PROTECTED] writes:
Gregory Stark [EMAIL PROTECTED] writes:
Tom Lane [EMAIL PROTECTED] writes:
I made it reject all but latin letters, which is the same restriction
that's in place for timezone set filenames. That might be overly
strong, but we definitely have to forbid
of Linux and I thought it was false
for other modern OSes -- I'm surprised it's not for Solaris even.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)---
TIP 6: explain analyze is your friend
901 - 1000 of 1641 matches
Mail list logo