?
This shouldn't really be possible without disabling autovaccuum or
configuring it strangely.
http://www.postgresql.org/docs/current/static/routine-vacuuming.html#VACUUM-FOR-WRAPAROUND
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
it out.
SELECT levenshtein('1','2');
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-separated output.
I'd like there to be a header in my files. I have to use CSVs instead.
Late to the discussion, but it does work to set format=csv and delimiter
= E'\t' to get tab-separated. Be nice not to have to though.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing
pooler.
You'll also need to reduce work_mem to 1MB or so.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
want (b) and
monitor the replication lag.
[1] For various values of safely of course
[2] In the same mode - adding async slaves doesn't count
[3] Assuming a reasonable write load of course. Read-only databases
won't care.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing
to the business/project
and then decide how much time/money to spend protecting against each one.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
in behaviour.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
:
barman : Depende: python ( 2.7) pero 2.7.3-4 va a ser instalado
Depende: python-argcomplete pero no va a instalarse
Since when 2.7.3 isn't larger then 2.7.
Is that not complaining that it *wants* a version of python 2.7 and
you have larger?
--
Richard Huxton
Archonet Ltd
or communicated without the prior written consent of the
copyright owner.
Oh no, too late!
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
handle tracking the changes in PostgreSQL leaving you to just
handle the MySQL end. Timestamps will do the job as long as you are
careful to allow enough slack to deal with clock updates.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
the
fillfactor and with/without the GIN index while you do the updates. It's
possible your SSD is just behaving oddly under stress.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
not updating any
indexed fields (and you were, I think).
A GIN index is very expensive to update compared to btree too.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
faster then something else is
happening.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
in your first message. If not, simply
adding AND make_id md.make_id should help. Also (and you may well
have considered this) - for a normalised setup you'd just have the
model-id in imports and look up the make-id through the models table.
--
Richard Huxton
Archonet Ltd
--
Sent via
with
very little RAM and disk space. At least deliver additional conf files
for small, medium, large, huge setups.
--
Richard Huxton
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
hex format.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
the
database regularly too. I'd expect to have to do a little work to move
the data into an up-to-date version of PostgreSQL and it's always better
to know what issues you'll have before doing it for real.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general
On 16/11/12 19:35, Shaun Thomas wrote:
Hey guys,
So, we have a pretty beefy system that runs dual X5675's with 72GB of
RAM. After our recent upgrade to 9.1, things have been... odd. I
managed to track it down to one setting:
shared_buffers = 8GB
It does the same thing at 6GB. 4GB is safe
lost.
But before you do anything drastic, do steps #1 and #2.
--
Richard Huxton
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
more information about this deadlock like which queries
created it.
The error message shows which queries - your two UPDATEs. I'm guessing
either t1 or c1 are views and so refer to the same row with id 2710501.
--
Richard Huxton
--
Sent via pgsql-general mailing list (pgsql-general
that, it seems to work fine.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
'NOTIFY demoApp, ' || quote_literal(n_user);
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
automatically result in a null result.
And indeed, this:
SELECT * FROM pg_proc WHERE proname LIKE 'regexp_r%';
shows pro_isstrict is set to true, as it is for most other function.s
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
the replica could never catch up). You can
control how long before it switches:
http://www.postgresql.org/docs/9.1/static/hot-standby.html#HOT-STANDBY-CONFLICT
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
On 29/03/12 23:28, Pavel Stehule wrote:
select anum from t1 where anum = 4
union all select 100 limit 1;
I'm not sure the ordering here is guaranteed by the standard though, is
it? You could end up with the 4 being discarded.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general
.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
headings etc.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
just installed a script, which prints me out the top and ps axf information
for facing out the problem. I will post a snippet of the top here:
Combine that with this:
SELECT * FROM pg_stat_activity;
That will let you line up pids from top with active queries.
--
Richard Huxton
Archonet
to
the performance list. There are people there who are used to machines of
this size.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
://archives.postgresql.org/pgsql-admin/2011-09/msg00088.php
http://archives.postgresql.org/pgsql-admin/2011-09/msg00101.php
Do you have version 9.0 installed too?
--
Richard Huxton
Archonet Ltd
create temporary relation in non-temporary schema
Temp tables get their own schema, and each session (connection) gets
its own temp schema. So - don't qualify them by schema.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
1
2
3
(3 rows)
Try SELECT * FROM pg_namespace to see the various temp schemas being
created.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
users?
Yes. I believe it also invisibly adds it to your search_path too, the
same as it does with the pg_catalog schema.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
performance, new features and it will be
supported for longer.
--
Richard Huxton
Archonet Ltd
to int is because count() returns bigint.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
yours, then yours won't find a row to update. Otherwise my
changes could be overwritten without you knowing.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
need to check the manuals for full details on how to configure
your logging - I'd expect a zero-length file even if you weren't logging
anything to it. Might be worth checking the directory is owned by user
postgres (or whoever your server runs as).
--
Richard Huxton
Archonet Ltd
--
Sent
to visualise what happens, exceptions are
actually implemented using savepoints in plpgsql.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to the bottom of all my plpgsql
functions. It can get very confusing otherwise, as you've just demonstrated.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
find the windowing function syntax confusing, but it's
as the standards define I believe.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
you the queries it uses.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
though. See ALTER DATABASE or
ALTER ROLE.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
replication then Slony
can handle this.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 16/09/11 09:01, Guillaume Lelarge wrote:
On Fri, 2011-09-16 at 08:14 +0100, Richard Huxton wrote:
Odd that pgAdmin
doesn't give an error though.
Probably because the OP entered the Windows networking path in the Name
field, and didn't change the Host field. In which case, pgAdmin most
is working, try just the server-name by
itself. You'll want the internet name for the machine which in theory
can be different from the Windows network name, but usually is the same.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
think the key bit you're missing is the INHERIT on the group. Also
note that the CREATE USER/CREATE GROUP commands actually just run CREATE
ROLE under the hood.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
?
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
will be zero. Minus one will
give you a negative substring length.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
fillfactor less than 100 ?
That would be my immediate guess. Someone changed the fillfactor on the
table - that won't affect the existing data but will affect a restore.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
returns rows. Zero rows are still rows. What happens if you
just use dblink(...)?
http://www.postgresql.org/docs/9.0/static/contrib-dblink-exec.html
http://www.postgresql.org/docs/9.0/static/contrib-dblink.html
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql
?
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
they are seamless enough only you
can decide.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
or is it just not
tested against it?
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to unaligned tab-separated columns.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
=1000 width=0)
(actual time=5.142..551.624 rows=121 loops=1)
Filter: (box(locn, locn) @ '(20,20),(10,10)'::box)
Total runtime: 551.831 ms
(4 rows)
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
of you deal with
this situation?
PostgreSQL actually measures length in characters anyway, so varchar(10)
always holds 10 characters, whatever they are.
You'll need to have the appropriate database encoding for those
characters of course.
--
Richard Huxton
Archonet Ltd
--
Sent via
(0,0,0,32,13-1,73)),\n'
Fri Feb 1 00:00:00 1974
http://perldoc.perl.org/POSIX.html#mktime
http://linux.die.net/man/3/mktime
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
not testing the values
you think you are, or there is some issue with escaping of characters.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
database after populating them?
Is the locale the same on each machine/db?
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 01/09/10 21:32, Devrim GÜNDÜZ wrote:
On Wed, 2010-09-01 at 21:13 +0100, Richard Huxton wrote:
Could you have changed the fillfactor on some big tables/indexes in
the live database after populating them?
Nope. Even a pg_dump -h prod|psql backup_node resulted with the same
issue
either, but of course they're frequently
the same (as in your case).
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
application language will have its own library, but they all have
a similar prepare+exec option (and I think most use the C libpq
interface underneath).
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
and see if any packets
are being sent back and fore while there is no real traffic.
Oh, and please don't cross-post to multiple lists (particular
-cluster-hackers - can't see the relevance of that).
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general
On 30/07/10 16:57, Scott Frankel wrote:
On Jul 30, 2010, at 1:13 AM, Richard Huxton wrote:
On 30/07/10 07:52, Scott Frankel wrote:
I have a number of very long strings that each contain many instances of
semi-colons, single quotes, forward and back slashes, etc. I'm looking
for an efficient
and third graphs look
like a sinusoidal variation overlaid on a steadily increasing baseline?
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
of course...
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
the cause and cure?
Is there any way to reproduce this error?
Not without knowing more about how it happened, which we could only
investigate before you restarted the master.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
to
test.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
://www.xs4all.nl/~mechiel/projects/bomstrip/
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
/PostgreSQL/psqlODBC/lib/libkrb5.so.3 (0x00a2c000)
libgssapi_krb5.so.2 = /opt/PostgreSQL/psqlODBC/lib/libgssapi_krb5.so.2
libk5crypto.so.3 = /opt/PostgreSQL/psqlODBC/lib/libk5crypto.so.3
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
importing data from text files which are
5.7 Gb in total, and this causes the db size to grow to 34Gb.
Anything from double to ten times the size isn't unexpected, depending
on row-sizes and how many indexes you are talking about.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing
http://www.postgresql.org/docs/8.4/static/functions-xml.html
http://www.postgresql.org/docs/8.4/static/xml2.html
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
again).
3. If your PG files are in the standard directory then you should see an
error saying initdb refused to run.
4. That's it - it should all just work.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
, if you want to search attributes,
then store attributes. Parse out your XML and have an attributes table
(id, name, value, last_changed, changed_by). That's not brilliant
because every value will just be text, but at least each attribute is
its own row.
--
Richard Huxton
Archonet Ltd
the index.
What does it do, then? The output of EXPLAIN would be a start if EXPLAIN
ANALYSE is too expensive.
Oh - and how many rows will this actually update?
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
your configuration
values aren't very close to reality.
The first query should run faster if it has more work_mem available too.
At the moment, it's probably going back and fore doing an on-disk sort.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general
On 16/03/10 13:49, Richard Huxton wrote:
You could run an xslt transform over the xml fragments and extract what
you want and then use tsearch to index that, I suppose. Similarly, you
might be able to do the same via xslt and xquery.
Actually, if it's only attribute names you're interested
can have a more permissive system for them.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
have 10 mins spare.
This is 8.4.3, Linux 64-bit
http://www.enterprisedb.com/getfile.jsp?fileid=878
This is 8.4.1 Windows
http://www.enterprisedb.com/getfile.jsp?fileid=855
I'd guess it's somewhere between the two.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql
be that autovacuum_naptime is too
large for your workload, or (auto)vacuum_cost_delay is too high.
http://www.postgresql.org/docs/8.4/static/routine-vacuuming.html#AUTOVACUUM
http://developer.postgresql.org/pgdocs/postgres/runtime-config-autovacuum.html#RUNTIME-CONFIG-AUTOVACUUM
--
Richard Huxton
Archonet Ltd
it.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
access).
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
,
it is worth keeping up-to-date.
http://www.postgresql.org/docs/8.2/static/release-8-2-15.html
Do you think uninstalling this locale would fix this issue?
No. Can you post the end of the installer log-file you get? Or
preferably the whole file.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql
side of the website and wiki.
http://www.postgresql.org/developer/
http://developer.postgresql.org/index.php/Main_Page
http://wiki.postgresql.org/wiki/Development_information
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
that will get
displayed as ^M (ctrl+M = ascii 13 = CR).
You could just do: sed 's/\r/\\r/' ... though
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
. Have a trigger you don't know about.
2. Have another function of the same name, but in a different schema
that is being called by mistake. Add a RAISE NOTICE to the function to
find out.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
many) - not a
terribly useful scenario.
If you wanted to measure actual join costs, you'd need to repeat the
tests (say) 100-1000 times in a loop, optionally with prepared plans.
Varying WHERE clauses might be useful too, if that's how your real
application will work.
--
Richard Huxton
.
* The 64-bit version of the Odbcad32.exe file is located in the
%systemdrive%\Windows\System32 folder.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-FB435EA63BF0} Version: 8.2.0 Attributes: 0
PatchId: Native BaselineId: -
This isn't version 8.2.0 you're installing, is it? Because 8.2.15 is the
current release for that version.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
no login privileges so by removing dropdb this should
remove the possibility for any hacker chaos other than creating more
databases?
Or deleting/modifying all your data, presumably. If you don't trust the
linux user account, don't give it automatic login.
--
Richard Huxton
Archonet Ltd
') );
This will show you the size of mytable (formatted nicely).
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
need to cluster tables / restart the replication to get the
best case. Vacuuming needs to be a continual process.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
for the archives). The
session_replication_role was added in 8.3:
http://www.postgresql.org/docs/8.3/interactive/sql-altertable.html
That wouldn't have occurred to me. Definitely worth adding to the archives.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general
this.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 24/02/10 20:27, Joshua D. Drake wrote:
On Wed, 2010-02-24 at 20:22 +, Richard Huxton wrote:
On 24/02/10 20:06, Raymond O'Donnell wrote:
However, to address your immediate problem, you could try something like
this:
(i) Create a new column of type numeric or integer as appropriate
two ways to read that:
1. Dangerous in Perl - well, what isn't?
2. Dangerous in Perl - blimey, if they think it's dangerous, it must
make lion-wrestling safe.
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
to google for perl nested named subroutine.
That seems to give a set of relevant results. Includes perldiag,
perlref, our mailing lists and Apache's mod_perl (which makes sense).
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
based on the available information.
If you get it wrong, there's always ALTER TABLE :)
Coming in 9.1:
ALTER CUSTOMER ... SET REQUIREMENTS ...
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
1 - 100 of 2230 matches
Mail list logo