Hello,
today I stumbled across a interesting question about the order rows are dumped
out while exporting a database with pg_dump. I know questions like this are
around this list sometimes, but I think this is a bit more special.
First of all I know that dumping a database is a somewhat nondet
g but that would be a manual
process. So anyone out there with some other ideas (I found this interesting as
I'm getting a more insight view of my favourite database)?
Thanks in advance,
Jan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your s
ss. So anyone out there with some other ideas (I found this interesting as
I'm getting a more insight view of my favourite database)?
Thanks in advance,
Jan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
** No rule to make target `libpq.dll', needed by
`all-shared-lib'. Stop.
What is the correct way to get a static libpq?
I also found something like "make install enable_shared=no" but that did
not help.
Jan
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
I need a database capable of storing at least 12 million records per
table, mostly used for batch queries. Basically an invoice database.
Some tables could potentially store 100 million records.
mySQL5 contains many of the features or PostgreSQL, and I doubt that I
need all these features. Are the
I've been using PostgreSQL for about three
months. So far my only objection is that "pg_affected" provides the
number of attempts rather than the number of rows that are actually
changed. I could easily do that with a little counter.
I think PostgreSQL should be changed to return the
n
From: "Michael Fuhr" <[EMAIL PROTECTED]>
To: "Jan" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, February 10, 2005 12:31 PM
Subject: Re: [GENERAL] pg_affected Change Request
> On Thu, Feb 10, 2005 at 05:56:33AM -0500, Jan wrote:
> >
> > I write a
developer does the same “mistake” again.
Thanks
Jan
From: Jan Strube
Sent: Tuesday, February 10, 2015 12:03 PM
To: 'pgsql-general@postgresql.org'
Subject: Performance slowing down when doing same UPDATE many times
Hi,
we recently found a bug in one of our applications which
.006 rows=0
>loops=1)
>Index Cond: (account_row_inst = 101)
>Heap Fetches: 0
>Planning time: 0.635 ms
>Execution time: 0.137 ms
>(18 rows)
>
>
>--
>Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-general
Have you set up constraints on the partitions? The planner needs to know what
is in the child tables so it can avoid scanning them.
Jan
Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.
unt_row_inst = 101)
>-> Index Only Scan using account_part1_pkey on account_part1
>(cost=0.42..8.44 rows=1 width=0)
>Index Cond: (account_row_inst = 101)
>(6 rows)
You can have a look at pg_partman. It makes setting up partitioning quite easy
and provides a tool to easily move existing data from parent to child tables.
Jan
temp_tablespace gets full, how postgresql will
react/manage the situation?
Queries running out of space in pgsql_tmp will just cancel (and
rollback).
Jan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
ossibly re-read
http://www.postgresql.org/docs/9.4/static/continuous-archiving.html#BACKUP-PITR-RECOVERY
especially 24.3.3 and 24.3.4.
hth
Jan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
mp in a parallel way to do "logical" backups every night.
Regards,
Jan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
That seems to be a large drop. On the other hand 13 ms is also like a very
large network latency. On LAN your usually in the sub ms area. So going from
e.g. 0.2 ms to 13ms is 65 fold decrease. What is the network toplogy like?
Jan
Von meinem iPad gesendet
> Am 24.07.2015 um 18:59 schr
; 5000tps
>>
>> When I do it from a server that has a 13ms ping latency, it drops to 37tps.
>>
>> This is using the default pgbench script, is it to be expected?
>> If so, why?
>>
> Am 24.07.2015 um 20:06 schrieb Jan Lentfer :
>
> That seems to be a
ient? Can
the transaction wrapparound freeze problem indeed occur earlier? And
if so, could someone suggest a better query to monitor?
Kind Regards,
Jan Keirse
--
DISCLAIMER
http://www.tvh.com/glob/en/email-disclaimer
"This message is delivered to all addressees subject to t
On Thu, Jul 30, 2015 at 2:56 PM, Adrian Klaver
wrote:
> On 07/30/2015 02:55 AM, Jan Keirse wrote:
>>
>> Hello,
>>
>> we have some very write heavy databases and I have our monitoring
>> system watch the transaction age of my databases to be alerted befor
On Tue, Aug 4, 2015 at 6:24 AM, William Dunn wrote:
> Hello Jan,
>
> I think your calculation is slightly off because per the docs when
> PostgreSQL comes within 1 million of the age at which an actual wraparound
> occurs it will go into the safety shutdown mode. Thus the calculat
On Tue, Aug 18, 2015 at 1:00 PM, Jimit Amin wrote:
> Can I know normal, aggressive, best parameter settings for PostgreSQL.conf
> file for particular hardware.
>
> Like Linux x86_64 , 8 GB Ram
> , Linux x86_64 , 126 GB Ram
There's no generic answer because it depends on what you're doing with
the
ibly in another
database.
Can you provide a list of all databases and all schemas in them from the
9.4 install?
Regards, Jan
>
>
> Not sure why it is still looking for slony1_funcs.2.2.2 even though the
> version is upgraded to 2.2.4 and it is running fine. i do see
>
On Sun, Jul 17, 2016 at 12:47 AM, Jan Wieck wrote:
>
> The only thing I can imagine would be that there is another slony cluster
> (or
> remnants of it) hanging around in the 9.4 installation, possibly in
> another database.
>
>
That does reproduce the problem. I ran the new
e as well as in stddev.
The whole DB
looks more like it is cruising, than fighting.
This example isn't a big database (40-80GB) or anything exotic. Just a
write heavy OLTP
load.
Regards, Jan
> Andreas
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-gene
to be proven wrong, but I suspect you'll find zero
correlation between implementation of CoC's and number of contributions
and/or contributors.
A wider question to the other participants in this discussion: Is it
generally an accepted view that the growth of the community (in some
sense
tions easily takes over an hour during
which the table is locked.)
Is there some workaround for this?
Thanks,
Jan
--
DISCLAIMER
http://www.tvh.com/glob/en/email-disclaimer
"This message is delivered to all addressees subject to the conditions
set forth in the attached disclai
On Tue, May 3, 2016 at 3:22 PM, Tom Lane wrote:
> Jan Keirse writes:
> > I have a table that used to contain all data.
> > because it grew too big I added a partition trigger a long time ago and
> > since than all new data was added to small partitions. By now all dat
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA512
Are there any statistical libraries for postgresql?
I'd like to do something along the lines of:
UPDATE foo SET value=value+normdistsample(10, 0.2) WHERE id=1;
- --
Kind regards,
Jan Danielsson
-BEGIN PGP SIGNATURE-
Ve
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA512
Andrej Ricnik-Bay wrote:
> On 6/18/07, Jan Danielsson <[EMAIL PROTECTED]> wrote:
>>UPDATE foo SET value=value+normdistsample(10, 0.2) WHERE id=1;
> Something like this?
> http://www.joeconway.com/plr/
That looks too good
Hello,
I'm using PGDB with JDBC. In my app i need to select only portion of all
available rows. I know i can do it two ways:
1. I can use OFFSET and LIMIT SQL statements or
2. I can select all rows and then filter requested portion in Java.
My question - Does the second way significantly affect p
fine in my database initialization script.
I assume that "functions" aren't what I am looking for.. But is is
possible to store preparations some way so they survive past
connection/disconnections?
- --
Kind regards,
Jan Danielsson
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.7 (Net
On 10 Jul 2007 at 9:13, Hannes Dorbath wrote:
On 10.07.2007 03:09, novnov wrote:
> I have postgres 8.1 installed on ubuntu 6.10 via synapic package manager. I
> would like to install 8.2, but it's not offered in the list. I think 8.2 is
> offered on 7.x ubuntu, and I wonder if 8.2 will be offered
ys* touch
in *every* select *and* update and where the access pattern is always
resulting in an index scan. Only in that case, you save from having the
value right in the main tuple and don't need to pull it from the toast
table and also don't lose the optimization of
Hi all,
pg 8.2.4 on Fedora Core 6 x86-64, mostly default postgres.conf just
shared memory buffers increased to 256M. 1GB RAM.
I attempt to insert ~200k rows into table in one transaction from psql
console, calling stored function of plperlu language, which inserts row
by row via spi_exec_prepar
place?
TIA,
- Jan
---(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 do not
match
Hi all
I have problem with "convert" function. Previous behaviour was
SELECT convert('ján', 'UNICODE', 'SQL_ASCII');
===
jan
In postgresql 8.3 is quite new behaviour.
SELECT convert('ján', 'UNICODE&#x
c chars now. First you have
to encode from bytea to text
postgres=# SELECT encode(convert('ján', 'UNICODE',
'SQL_ASCII'),'escape');
encode
ján
(1 row)
you wont
postgres=# SELECT to_ascii(encode(convert_to('ján',
'latin2'
Hi all
I have following problem when I use this
select headline('asd asd asd asd asd asd asd asd asd asd asd asd more more
more more more more more', to_tsquery('asd'), '');
I got this
"asd asd asd asd asd asd
asd asd asd asd asd asd more
more more"
So result is shorted than original
Thanks a lot. It helps.
On Fri, 04 Jan 2008 16:54:32 +0100, Oleg Bartunov <[EMAIL PROTECTED]> wrote:
On Wed, 2 Jan 2008, Jan Sunavec wrote:
Hi all
I have following problem when I use this
select headline('asd asd asd asd asd asd asd asd asd asd asd asd more
more more more mor
ted on two different WinXP machines with JDK 1.6.
Regards,
Jan Ischebeck
---(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 do not
match
"
Second problem is most important. On that line is first UTF8 character. I
read that it's necessary install patch tsearch_snowball_82.gz. But I am
running under windows and I am not so skill for windows compilation. I
thought that lastest PostgreSQL version has this patch included.
Thanks for help.
Jan Sunavec
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
done on purpose ? What is the correct way to restore a named table
?
I know I can use the -t switch during the dump and then restore without
using -t but I would like to avoid this solution. The files I can work on
are dumps of the entire DB.
Thanks for your help,
Jan
aint is NOT listed when I do
pg_restore -l /tmp/mydump -t my_table
In any case, shouldn't the documentation describe more the pg_restore
-t command ? It's really misleading and one can discover this only by
running into problems.
Thanks for your help,
Jan
On Fri, Oct 29, 2010
an index. This
> should be set to the amount of memory allocated to shared_buffers
> plus the amount of OS cache available. Often this is more than 50% of
> the total system memory.
So don't worry - everything is fine. You should pay attention that your
system doesn't start swap
reoder it accoring to an index or something).
Jan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> eg, insert into logtable values ( 'vehicle123', now(),
> {{'voltage','13'},{'rpm','600'}};
>
> However, I am not sure how I can write a query - for example to read all
> records where the voltage field is less than 13. Performance in this case is
> not a real significant issue.
>
> Would I
0:00.00453
NOTICE: 00:00:00.004976
The problem only occurs inside a transaction and if the same dataset is
updated. I´m using PostgreSQL 9.1.15.
Jan
an on "W_BASE" wb (cost=0.00..93399.55 rows=1474955 width=207)
I tried reducing work_mem from 8MB to 64kB to force usage of temporary
files for the hash joins instead of working memory, as written in
chapter 18.4.1 of the documentation. But that didn´t help.
I know tha
Hi,
you are right.
We were running 9.1.4 and after upgrading to 9.1.7 the error disappeared.
Thanks a lot,
JanStrube
I'm getting an out of memory error running the following query over 6
tables (the *BASE* tables have over 1 million rows each) on Postgresql
9.1. The machine has 4GB RAM:
It l
quot;ISIN" IN (SELECT "ISIN" FROM dtng."Z_BASE" LIMIT 1)
We already found out that the problem is the Perl function "get_comment"
which is very expensive. In the first case the function is called at
most once, but in the second case it is called many times. I b
is your function stable/immutable, and if so is it decorated as such.
merlin
No, it´s volatile.
Jan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
rated from the
function which stores the COMMENT in cached_comments for the next select.
Is there perhaps a best practice to do a thing like that? Of course we
could declare the original function stable and call another volatile
function to store the data, as noted in the docs. But that would
txt
Does anyone have an idea what could be wrong here or how I can find out
where the memory is spend?
Thanks a lot,
Jan
P.S.: Here´s the log:
<2013-02-18 16:51:26 CET - idms_export> CONTEXT: PL/Perl function
"get_comment"
TopMemoryContext: 1272045600 total in 657683 block
On 06/24/13 10:24, Rebecca Clarke wrote:
> I could be wrong, but shouldn't the owner of .pgpass be postgres?
The owner of ~/.pgpass is whoever owns ~ (the home directory of that user).
And ~/.pgpass must have permissions 0600 in order for libpq to actually
use it.
Jan
>
>
&g
On Fri, Apr 28, 2017 at 4:39 PM, Andrew Kerber
wrote:
> I am a fairly experienced Oracle DBA, and we are starting to move in to
> the PostgreSQL world. I would expect the standard monitoring items are
> required for mission critical postgres apps, Ie, disk space, wal log space,
> log monitoring,
've had queries in the past which work in
postgresql which I couldn't run in sqlite, but this is the first time I
can recall where a query works in sqlite but not in postgresql).
--
Kind regards,
Jan Danielsson
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
nually, of
course).
See /etc/apt/apt.conf.d/50unattended-upgrades (the default version of
that file includes documentation as comments).
Also see the unattended-upgrade(8) manpage, and the on/off switch in
/etc/apt/apt.conf.d/20auto-upgrades
--
Jan Claeys
--
Sent via pgsql-general mailing list
ELECT statements aren't by chance FOR UPDATE, are they?
Jan
--
Anyone who trades liberty for security deserves neither
liberty nor security. -- Benjamin Franklin
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, pleas
button "Start", the installation-program writes the message
"Prepare to install" in a short period, and after that nothing is happening.
What is wrong ???
I enclose the logfile.
My e-mail-address is : [EMAIL PROTECTED]
I hope to hear from you.
Bes
because up to version 1.2.x, Slony is deliberately corrupting
the system catalog on subscriber nodes in order to suppress triggers and
rules to fire (this can only be controlled by other means since Postgres
8.3 and will be done so in Slony 2.0).
Jan
- Original Message
From: Glyn
On 4/5/2008 11:02 AM, Glyn Astill wrote:
Hi Jan,
Is that still true for 1.2.12? As that's the version I'm using.. Also any ideas
on where I start to sort it out? I just want to drop the old table now I've
removed it from replication, but the error mentioned previously is sto
_
¹) Also later on tags such as and at other times something
else depending on the circumstances.
//Jan-Erik
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
n my opinion.
I didn't intend to try it either before I spotted some of those
functions... :-)
Then figured it would be nice to do it within the db-engine as all the
data is present there.
I wrote code outside the db-engine some time ago, but then other
aspects made it less desirable to use.
>
> Cheers
>
> Andy
>
Thank you Andy for the code example and your advice.
I really appreciate that you took your time to show me how and explain
why.
//Jan-Erik
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
but that's something I need a bit
of help with (hint, hint).
Written to run on eComStation v2.0 (successor of OS/2)
//Jan-Erik
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi All,
I was looking in what way it's possible to alert via mail when some conditions
are true in a database.
Thanks in advance!
Jan
blems with dblink on Snow Leopard?
i dont use dblink so i cant say if it is broken on my machine too.
regards, jan otto
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Configure completes ok.
When I do a "make 2>mylog.log"
i have tried configuring an building with the same options as you and
it compiles without an error or warning
about python.
regards, jan otto
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make ch
didn't configure it) would make a difference.
try killing mDNSResponder before restarting postgres:
sudo killall mDNSResponder
hopefully apple fixes this dns-problems in 10.6.1.
regards, jan otto
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes t
hi jerry,
try killing mDNSResponder before restarting postgres:
sudo killall mDNSResponder
hopefully apple fixes this dns-problems in 10.6.1.
regards, jan otto
The rascal gets respawned immediately ;(
Of course it will be respawned, but all the cache is disposed (the
broken entries
not one I agree with and I don't want a
Google search years from now to tie my name to that viewpoint.
Who (in their right mind) would ever think of anything but BSD in a
server role?
Jan
--
Jan Wieck
Senior Software Engineer
http://slony.info
--
Sent via pgsql-general mailing list
getting in the way then cancelling them is
still harmful, it's just not postgres' fault.
Slony (even the very old 1.2) does not cancel anything explicitly.
Jan
--
Jan Wieck
Senior Software Engineer
http://slony.info
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
hould be to issue
STORE PATH commands with the new IP/hostname to the Slony replica(s).
Regards,
Jan
--
Jan Wieck
Senior Software Engineer
http://slony.info
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mai
ractical purposes a small subset of functionality through
some gateway service would probably be a better approach.
Note that I am not an Arduino user/developer. I'm more familiar with the
Microchip PICs.
73 de WI3CK
--
Jan Wieck
Senior Software Engineer
http://slony.info
--
Sent via pgsql
message bus or queue.
The bus/queue receiver will then push the data into the database or
whatever downstream system.
Jan
--
Jan Wieck
Senior Software Engineer
http://slony.info
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
secure IP connections, directly
connect to a database, that is hosted on a publicly accessible VPS?
Maybe it is just me, but to me that design has DISASTER written in bold,
red, 120pt font all over it.
Good luck with that,
Jan
--
Jan Wieck
Senior Software Engineer
http://slony.info
--
Sent via
code complain about the mismatch instead of the bogus WAL message?)
>
Slony [2] or PGBouncer+Londiste [3] should allow you to do this in an
integrated fashion. [4]
Cheers,
Jan
[1] http://www.postgresql.org/docs/current/static/warm-standby.html
[2] http://slony.info/
[3] http://itand.me/zero-dow
ot;:1,"project_name":"prj1"}}
i thought of something like this:
select
row_to_json(t1)
from (
select
'joe' as username,
(select * from (values(1, 'prj1')) as project(project_id, project_name)) as
project
) t1;
but this fails with "ERROR: s
big thanks, this is exactly what i was looking for.
jan
Am 13.08.2012 um 17:58 schrieb Merlin Moncure :
> On Sat, Aug 11, 2012 at 7:05 AM, jan zimmek wrote:
>> hi,
>>
>> i am looking into json support of the upcoming 9.2 release and have a
>> question about the row
On Mon, Oct 1, 2012 at 11:43 AM, Andreas Pfotenhauer wrote:
> OS is debian squeeze, pg installed is the latest 9.2.1 from
> pgapt.debian.net. Logs where checked, no errors/warnings at all. Query plans
> have been checked, no changes before/after. The changed behavior only
> manifested in the drop
blogin/lib/postgresql/tablefunc.so: wrong ELF class: ELFCLASS32
On google I didn't only find some clues, that this seems related to 64bit
vs. 32bit.
Please help or point me in the right direction.
Jan
an" or
>"make maintainer-clean" before configuring and building again.
1. You refer to my installation of postgresql-9.1.3 ? as far as I
understand the tablefunc I am trying to load is included there
2. Would I need to "uninstall" postgresql-9.1.3 somehow before running
Thanks a lot, this worked. I read to detail the tablefunc.so and then go to
the postgres-9.1.3/contrib/ and call make + make install there.
On 20 October 2012 20:02, Jan Mechtel wrote:
> Thanks for the quick reply,
> This could indeed be a solution since the webhosting migrated the old
&g
blogin/lib/postgresql/tablefunc.so: wrong ELF class: ELFCLASS32
On google I didn't only find some clues, that this seems related to 64bit
vs. 32bit.
Please help or point me in the right direction.
Jan
an" or
>"make maintainer-clean" before configuring and building again.
1. You refer to my installation of postgresql-9.1.3 ? as far as I
understand the tablefunc I am trying to load is included there
2. Would I need to "uninstall" postgresql-9.1.3 somehow before running
there).
Think about how you data is structured and how it is queried after it
was imported into the database to see where your bottlenecks are.
Cheers,
Jan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi all,
> I would very much appreciate a copy or a link to these slides!
here they are:
http://www.scribd.com/mobile/doc/61186429
Have fun!
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-ge
n/postgres -D /var/lib/pgsql/data
That sould start your instance in foreground so you should see any
errors and messages during startup.
One more thing: is SELinux enabled?
Hope that helps :-)
Jan
On 19.12.2012 16:34, Jason Ma wrote:
> Hi,
>The ps output is after the server start, I
;t come to this
and that I could have returned to active duty earlier. Things in my
little sub universe didn't change as fast as we all hoped and we all
think it is best now that I focus on getting back to speed and do some
serious hacking.
I hope to see many of you in Ottawa.
Regards
Jan
t has something to do with
composite types).
Can anyone please explain?
Thanks,
Jan
smime.p7s
Description: S/MIME Cryptographic Signature
Am 31.05.2010 17:44, schrieb Tom Lane:
Richard Broersma writes:
On Mon, May 31, 2010 at 7:48 AM, Jan Strube wrote:
I accidentally encountered a feature in Postgres 8.3 that I couldn't find in
the documentation while submitting a query like
SELECT my_table.varchar FROM my_
W.a = 4) THEN INSERT INTO support.partitionD VALUES (NEW.*);
ELSE RAISE EXCEPTION 'A (%)is out of range ',NEW.a;
END IF;
RETURN NULL;
a trigger for insert should return NEW, no? ;-)
change that and it will work.
regards, jan
--
Sent via pgsql-general mailing list (pgsql-general@post
hi,
is an initdb and pg_upgrade required when upgrading from 9.0rc1 to final 9.0?
there is no mention about that in the release notes.
regards, jan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
>> is an initdb and pg_upgrade required when upgrading from 9.0rc1 to final 9.0?
>> there is no mention about that in the release notes.
>
> No, there were no system catalog changes between 9.0rc1 and 9.0.
thank you bruce.
regards, jan
--
Sent via pgsql-general mailing l
>> is an initdb and pg_upgrade required when upgrading from 9.0rc1 to final 9.0?
>> there is no mention about that in the release notes.
>
> No, there were no system catalog changes between 9.0rc1 and 9.0.
thank you bruce.
regards, jan
--
Sent via pgsql-general mailing l
u must do so. it
> never hurts to keep the old binaries around, 'just in case' though
> :-).
thank you merlin.
regards, jan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
;
Jan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
olors select 'yellow';
INSERT 0 1
# select count(1), color from colors group by color;
count | color
---+
2 | red
3 | yellow
1 | green
(3 rows)
Jan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
standard c (libSystem) function. make shure you
have linked your library (libpq) against the same versions of
standard libraries as you try with your iphone-app.
check your linker options, specially -isysroot.
you can check later to which libSystem your lib or app was built
with: otool -L
regards
hi
i've got the database (about 300G) and it's still growing.
i am inserting new data (about 2G/day) into the database (there is
only one table there) and i'm also deleting about 2G/day (data older
than month).
the documentation says, one should run VACUUM if there are many
changes in the databa
2010/4/14 John R Pierce :
> Jan Krcmar wrote:
>>
>> hi
>>
>> i've got the database (about 300G) and it's still growing.
>>
>> i am inserting new data (about 2G/day) into the database (there is
>> only one table there) and i'm also
hi
2010/4/14 Adrian von Bidder :
> -> vacuum can run concurrently to other stuff, so it's not necessary to
> wait before it finishes.
> -> in most cases, autovacuum should do the Right Thing(tm) atomatically, so
> you should not need to call vacuum manually.
>
> This is with a recent pg version.
1 - 100 of 570 matches
Mail list logo
