test that à la:
What I do is use grep, for example (off the top of my head):
if ! psql -qAt -c "select usename from pg_user" | grep -q USERNAME ;
then
...
If you're looking for true/false you could grep for t/f.
Hope this helps,
--
Martijn van Oosterhout <klep...@svana.org>
generally way easier to run your unit
tests on an actual PostgreSQL database. Otherwise you're going to spend
all your time working around the fact that your mock database is not
the real thing (and running into bugs in your emulation layer).
Have a nice day,
--
Martijn van Oosterhout klep
them that
way...
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
not attach much importance to his own thoughts.
-- Arthur Schopenhauer
signature.asc
Description: Digital
)))
(2 rows)
If you look carefully you'll see that the comparison here is done as a
double precision and so can't use the index. If you say something
like:
WHERE customer_id = trunc( random()*45000)::bigint
it will probably work fine.
Have a nice day,
--
Martijn van Oosterhout klep
to make this work, but it saves you
from any quoting issues.
Of course, it gets more complicated if you want to allow cases like:
PREPARE get_by_id AS SELECT * FROM IDENTIFIER($1) WHERE id=$2;
EXECUTE get_by_id('mytable', 400);
But DDL would be a great start.
Have a nice day,
--
Martijn van
in future
protocol versions.
It will take a while for TLS 1.3 to be deployed so there's time, but
PostgreSQL protocol revisions go at a similar pace.
Have a nice day,
[1] https://github.com/tlswg/tls13-spec
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes
showing the problem (and
server version).
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
not attach much importance to his own thoughts.
-- Arthur Schopenhauer
signature.asc
index idx_1 on peter_hicks ((case when id is null
then 'NULL' else '' end)) where id is null;
CREATE INDEX
Time: 14,803 ms
Note: COALESCE is probably the better choice here.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly
interested in ranges,
see for example:
http://www.postgresql.org/docs/9.2/static/rangetypes.html
Conceptually they are a bit different and there isn't support for
multi-ranges AFAIK but they might be more appropriate.
Hope this helps,
--
Martijn van Oosterhout klep...@svana.org http
... ORDER BY vote DESC
) SELECT * from cte order by path, votes desc;
Hope this helps,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
not attach much importance to his own thoughts.
-- Arthur
,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
not attach much importance to his own thoughts.
-- Arthur Schopenhauer
signature.asc
Description: Digital signature
later the system had arrived at 102 files
Is autovacuum enabled? Are you using a lot of temporary tables? Do you
have long running transactions?
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset
() that does what you want.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
not attach much importance to his own thoughts.
-- Arthur Schopenhauer
signature.asc
Description
not
enable this option, hence they (probably) have no effect.
(Discovered after finding processes staying alive for several months
because the firewall had lost it's state table at some point).
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes
, except they're not
crash safe.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
not attach much importance to his own thoughts.
-- Arthur Schopenhauer
signature.asc
the Debian README?
/usr/share/doc/postgresql-*/README.Debian.gz
It talks about how the certificates are made. It uses the ssl-cert
package to make them, there's more docs there.
Yes, you can make your own self-signed certs and use them.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org
,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
not attach much importance to his own thoughts.
-- Arthur Schopenhauer
signature.asc
Description: Digital signature
.
Essentially, the processor can encrypt/decrypt data so much faster than
the cost of reading/writing to disk, you don't notice the difference.
There's surely a difference, but if this means you meet your
requirements it's an excellent solution.
Have a nice day,
--
Martijn van Oosterhout klep
running with ps. Maybe you typoed the
config file?
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
not attach much importance to his own thoughts.
-- Arthur Schopenhauer
on the master.
I can make a script on the master that deletes files older than an
hour, but that will break horribly if the copying breaks for an hour.
Is there a smarter way to do this, like having rsync not copy stuff
already copied once?
Thanks in advance,
--
Martijn van Oosterhout klep...@svana.org
On Mon, Jan 06, 2014 at 07:16:25AM -0800, Adrian Klaver wrote:
On 01/06/2014 03:18 AM, Martijn van Oosterhout wrote:
Hoi,
I've setup a up WAL shipping configuration as described in the wiki. On
the master I have:
archive_mode= on
archive_command = 'cp %p /path_to/archive/%f
On Mon, Jan 06, 2014 at 08:17:37AM -0800, Adrian Klaver wrote:
On 01/06/2014 07:35 AM, Martijn van Oosterhout wrote:
On Mon, Jan 06, 2014 at 07:16:25AM -0800, Adrian Klaver wrote:
On 01/06/2014 03:18 AM, Martijn van Oosterhout wrote:
Hoi,
I'm not sure what you mean, isn't
There is a measurable reduction in elapsed time for my code when I
specify IPC. My code uses:
node.js
https://npmjs.org/package/odbc
db2
In general, in postgres you leave the the hostname blank to specify
local IPC.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog
it matched now rows at all. And if this is the
complete plan, it took 1,500 seconds for itself.
Hope this helps,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
not attach much importance to his
CONSTRAINT attr1_a_fkey1 FOREIGN KEY (a, b) REFERENCES
events(a, b)
Voila!
Am I missing anything? It's not pretty, but it reduces the problem to a
few short exclusive locks, rather than hours of downtime scanning
tables.
PG 9.1.10 FWIW.
--
Martijn van Oosterhout klep...@svana.org http
a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
not attach much importance to his own thoughts.
-- Arthur Schopenhauer
signature.asc
Description: Digital signature
a partition I actually see the disk usage drop.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
not attach much importance to his own thoughts.
-- Arthur Schopenhauer
.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
not attach much importance to his own thoughts.
-- Arthur Schopenhauer
signature.asc
Description: Digital signature
,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
not attach much importance to his own thoughts.
-- Arthur Schopenhauer
signature.asc
Description: Digital signature
day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
not attach much importance to his own thoughts.
-- Arthur Schopenhauer
signature.asc
Description: Digital signature
platform.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
not attach much importance to his own thoughts.
-- Arthur Schopenhauer
signature.asc
Description: Digital signature
performence problems and instability.
Someone wrote a nice blog about it once and coined a term, but I've
forgetten what.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
about it and it turns out that I was running a somewhat
old version, and it was fixed in later versions.
Check that first. But ask anyway, I've always found the Slony guys very
helpful.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes
heard of anything like the weird cases you get with those
American green cards.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
not attach much importance to his own thoughts
float output by default, but also
provides a // operator to access the truncated version.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
not attach much importance to his own
,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
not attach much importance to his own thoughts.
-- Arthur Schopenhauer
signature.asc
Description: Digital signature
,tuple)' to start scanning
at a particular spot in the table.
It's not automated, though it might not be hard to do.
Hope this helps,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
not attach much
which you can check-in safely. Not super safe, but for
read-only accounts for e.g. nagios might be ok.
Hope this helps,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
not attach much importance
day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
not attach much importance to his own thoughts.
-- Arthur Schopenhauer
signature.asc
Description: Digital signature
for you.
As for no SQL level functions, you could probably write a function to
determine the scale/precision of a given *value*, but not for a whole
column. But once you have to string representation of the value you
have that anyway...
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org
is something I never do.
The system tables carry estimates which have proved good enough for
statistical purposes when I need them.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
and hence be much faster than any of the above
suggestions, so if this is a really important query then it may be
worth it here.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
)
Index Cond: (b = 1)
(4 rows)
In this case a row update will only update indexes with non-NULL rows,
which may cut the overhead considerably.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very
On Tue, Aug 21, 2012 at 09:39:20AM +0800, Craig Ringer wrote:
On 08/21/2012 03:06 AM, Martijn van Oosterhout wrote:
I'm not sure I have an opinion on pushing ORM features to the database
layer, SQLAlchemy is doing a pretty good job for me already.
There are some things ORMs could really use
in an order which you could derive
from a foreign key, compared to items in an order which have sales
tax which is something more general.
So whatever the result of this discussion, don't just consider foreign
keys, think bigger.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http
it taking a while for
your disk cache to reach steady state after a reboot can mean that you
see a higher than normal load for a while.
But 0.88 is really nothing to worry about. Perhaps it is just slower
core or a slower memory bus.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org
, then it may be that your disk
subsystem has slow fsyncs.
Hope this helps,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
not attach much importance to his own thoughts.
-- Arthur Schopenhauer
perl/python implementations but
AFAIK they are not widely used.
It's not common to not use libpq.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
not attach much importance to his
the desired effect? This is a well understood and commonly
used paradigm. When using a connection pooler any query plan caching
will happen automatically.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very
this error can occur. Linux does it if
you ask for O_DIRECT on a filesystem that doesn't support it, but it
doesn't look like that's the problem here either.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby
collection. You must use PQclear.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
not attach much importance to his own thoughts.
-- Arthur Schopenhauer
signature.asc
updating.
Hope this helps,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
not attach much importance to his own thoughts.
-- Arthur Schopenhauer
signature.asc
Description: Digital signature
out file fragmentation. this way the IO workload is
evenly distributed across all the disks.
That, and a good RAID controller with BBU cache will go a long way to
relieving the pain of fsync.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who
a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
not attach much importance to his own thoughts.
-- Arthur Schopenhauer
signature.asc
Description: Digital signature
day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
not attach much importance to his own thoughts.
-- Arthur Schopenhauer
signature.asc
Description: Digital signature
was true when the code was written, but still.
Hve a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
not attach much importance to his own thoughts.
-- Arthur Schopenhauer
returning multiple
rows.
Any ideas what's going on here?
As pointed out by others, you don't say if it this is a race condition
between processes or if it always does this.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses
in the OPs case they are relying on the customer to install
PostGIS. The GPL only applies to *redistribution* not usage. So if
you're not supplying your customers with PostGIS then the fact that
it's GPL seems completely irrelevent.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org
in
postgres, it's really a very active project.
[1] http://www.youtube.com/watch?v=gzTBJW2EVJY
[2] code.google.com/???p/???gource/
[3] github.com/???postgres/???postgres
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly
Notwithstanding the rest of your post, I'm surpised you missed the
website:
http://www.postgresql.org/download/
There's a source code link, as well as several others.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby
in an IN and see what happens.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
not attach much importance to his own thoughts.
-- Arthur Schopenhauer
signature.asc
is as follows:
Might not work if you have non-ascii characters (but your example code
breaks there too), but what about:
DELETE ... WHERE upper(name) = name;
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby
van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who writes carelessly confesses thereby at the very outset that he does
not attach much importance to his own thoughts.
-- Arthur Schopenhauer
signature.asc
Description: Digital signature
not be a problem - I have another 64
bit CentOS where both queries are executed displaying identical results.
It's probably locale related. Postgres uses the same order as the
sort command.
Try show lc_collate.
Hope this helps,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
He who
... END;
http://www.postgresql.org/docs/8.4/static/functions-conditional.html
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
Patriotism is when love of your own people comes first; nationalism,
when hate for people other than your own comes first
.
This applies to any SQL database.
You can somewhat enforce order with subselects and CASE and other such
constructs.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
Patriotism is when love of your own people comes first; nationalism,
when hate for people other
with ps/wchan.
It's unfortunate you don't have debug symbols enabled, which makes
these traces somewhat unreliable. So you get odd things like index_open
calling index_close.
The common factor seems to be lots of index locks. Do you have very
many indexes?
Have a nice day,
--
Martijn van Oosterhout
,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
Patriotism is when love of your own people comes first; nationalism,
when hate for people other than your own comes first.
- Charles de Gaulle
signature.asc
Description: Digital
On Sat, Mar 05, 2011 at 07:38:23AM -0800, ray wrote:
This has been a great thread! I am missing something because I do not
know what CTAS is. WOuld someone please help me understand.
Create Table As Select.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org
. This is the
timestamp without time zone.
The latter is usually not that useful, except for output. What you
usually want is the timestamptz.
Hop this helps,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
Patriotism is when love of your own people comes first; nationalism,
when hate
did not support sorting in UTF-8. I know Apple
added it themselves because they needed it but I don't think it got
backported to *BSD.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
Patriotism is when love of your own people comes first; nationalism
easily do it by setting the default
search path per user.
ALTER USER phpbb SET search_path='phpbbschema';
As long as the apps don't play with the search path themselves it
should be fine.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
Patriotism is when
.
The suggestion to simply reload the database as if all the current data
was WIN1251 or Latin-9 is a fairly easy way to getting the database
into a reasonable format. The data would have to be checked though.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org
times and use that to
predict which would be better. There's always pathelogical cases, but
it could work well for normal workloads.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
Patriotism is when love of your own people comes first; nationalism,
when
without + even from a bigger client most often I forgot
The mailing list manager has several options which may be relevent
here. There is a reply-to option which may do what you want:
http://mail.postgresql.org/mj/mj_wwwusr/domain=postgresql.org
Have a nice day,
--
Martijn van Oosterhout klep
=e6721c6e1617a0fc8b4bce8eacba8b5a381f1f21
Line Number 53, Column 4:
Trynbsp;tonbsp; ...
^
Is it just my browser being pedantic (Firefox 3.6) or something else?
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
Patriotism is when love of your own people comes first
day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
Patriotism is when love of your own people comes first; nationalism,
when hate for people other than your own comes first.
- Charles de Gaulle
signature.asc
Description: Digital
consistantly and
replays them if the database crashes.
If you take a snapshot the database will simply startup and replay the
log as if the machine crashed at the point. All committed transactions
appears anything uncommitted vanishes.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org
, or fewer but more complex queries?
Basically, what's the workload?
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
Patriotism is when love of your own people comes first; nationalism,
when hate for people other than your own comes first
,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
Patriotism is when love of your own people comes first; nationalism,
when hate for people other than your own comes first.
- Charles de Gaulle
signature.asc
Description: Digital
found that reducing this tends to smooth
out bursty spikes. However, see:
http://www.westnet.com/~gsmith/content/linux-pdflush.htm
which indicates that kernel may try to defeat you here...
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
Patriotism
you have fully understood this page:
http://www.postgresql.org/docs/8.4/static/xfunc-c.html
it has a number of examples dealing with variable length types. You
MUST use the VARDATA/VARATT/etc macros to construct and read your data.
Hope this helps,
--
Martijn van Oosterhout klep...@svana.org
);
mempcy (realResult, result, result-length);
Did you define the type properly at SQL level? Is it a varlena type or
fixed length? Did you return it properly (as Datum)?
You're going to need to post more information before we can help you
usefully.
Have a nice day,
--
Martijn van Oosterhout
the literal as '1' (with quotes) postgres would happily downcast
it for you without any problem.
The question is: does the column really need to be smallint.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
Patriotism is when love of your own people comes
SQL. So you might be able to declare the function, but in no way could
you actually call it successfully.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
Patriotism is when love of your own people comes first; nationalism,
when hate for people other than
); 212542976 used
TupleSort: 369090584 total in 46 blocks; 7648 free (25 chunks);
369082936 used
That's a few hundred MB also. I'd suggest checking your work_mem
settings to see if you havn't gotten too much configured.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http
you're missing is that in postgres NULLs are stored as a bit in
the header and there is no data. So in a sense NULLs take no space
(well, one bit) which means both statements are true.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
Please line up
The workaround is simple, use a cast instead, but is there a particular
reason why you can't use a parameter there?
This does work, oddly enough.
postgres=# prepare test2 as select timestamp '2009-01-01' at time zone $1;
PREPARE
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
Please line up in a tree and maintain the heap invariant while
On Wed, Feb 24, 2010 at 09:13:36PM -0500, Greg Smith wrote:
Martijn van Oosterhout wrote:
I remember a while back someone posted a graphs showing a scalability
of postgresql for various versions (I think 8.0 to 8.4). I've tried to
find this image again but havn't been able to locate it. Does
Hoi,
I remember a while back someone posted a graphs showing a scalability
of postgresql for various versions (I think 8.0 to 8.4). I've tried to
find this image again but havn't been able to locate it. Does anyone
here remember?
Mvg,
--
Martijn van Oosterhout klep...@svana.org http
a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
Please line up in a tree and maintain the heap invariant while
boarding. Thank you for flying nlogn airlines.
signature.asc
Description: Digital signature
of the allocations are quite small, but
postgresql has an internal allocator which means that the system only
sees relatively large allocations. The majority will be in the order of
tens of kilobytes I suspect.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org
you'd be sending your paramters out of line anyway.
Can you check that?
Hope this helps,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
Please line up in a tree and maintain the heap invariant while
boarding. Thank you for flying nlogn airlines.
signature.asc
at all at the libc level (that is, if you don't
just tell people to use ICU in that case).
Mac OS X doesn't have great POSIX locale support but at least they
implemented strcoll_l.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
Please line up in a tree
the
TRUNCATE command to abort if it takes too long.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
Please line up in a tree and maintain the heap invariant while
boarding. Thank you for flying nlogn airlines.
signature.asc
Description: Digital signature
underneath
for programs that would like true unicode collation, but there is
little chance that postgresql will ever use this.
Hope this helps,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
Please line up in a tree and maintain the heap invariant while
boarding. Thank you
unchanged but newer scripts can choose UTF-8 if they
want it.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
Please line up in a tree and maintain the heap invariant while
boarding. Thank you for flying nlogn airlines.
signature.asc
Description
-809a-dc9931a01ed1']::uuid[];
The syntax is '= ANY(foo)', you're missing the parenthesis.
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
Please line up in a tree and maintain the heap invariant while
boarding. Thank you for flying nlogn airlines
=shift;
test();
return $test;
sub test {
print X=.$test.\n;
}
}
main(1);
main(2);
Output:
X=1
X=1
Have a nice day,
--
Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/
Please line up in a tree and maintain the heap invariant while
boarding. Thank you
1 - 100 of 1908 matches
Mail list logo