On Mon, Aug 16, 2010 at 4:01 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Greg Smith g...@2ndquadrant.com writes:
The other alternative here is to just tune autovacuum so it runs really
slowly, so it won't kill responsiveness during any peak period. While
in theory that's the right thing to do,
On Sun, Jan 25, 2009 at 1:47 PM, Ezra Taylor ezra.tay...@gmail.com wrote:
All:
Do any of you have gripes about using XFS with the latest version of
postgres?
I'd not expect there to be much specific benefit to it...
I did some benchmarking, now quite a while ago, which showed XFS to
carl [EMAIL PROTECTED] writes:
Greetings All,
I'm working on a specification for an Enterprise-class Open Source
batch scheduler, and I really would like some expert commentary from
experienced database people. Please have a look at:
http://openjcs.sourceforge.net
and the specification to
In the last exciting episode, [EMAIL PROTECTED] (Ezequias Rodrigues da Rocha)
wrote:
Hi list (my first post),
Is there any password polity that postgresql implement ?
No, that would be a serious mistake, as it would prevent people from
having local policies that differed
After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (Joshua Kramer)
belched out:
Hello All,
What strategies are people using for automated, script-based backup of
databases? There are a few I can think of:
1. Create a db_backup unix user and a db_backup pgsql user. Grant
READ
After a long battle with technology, [EMAIL PROTECTED] (adey), an earthling,
wrote:
Please could someone give me an idea of what pgpool is, and where I can
research it?
I have run a search on postgresql.org and found many references, but
they don't explain what it is, and it doesn't appear
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED]
(Praveen Kumar N) transmitted:
hai...
i have some problem with installing postgresql.
Following is the output of installation:
--
[EMAIL
[EMAIL PROTECTED] (Michael Fuhr) wrote:
On Sat, Jun 10, 2006 at 07:29:52PM +0100, Andy Shellam wrote:
I'm using a great little Linux program called monit to check that
there's something listening on the 5432 port. It also monitors
individual process memory and CPU usage etc. Quite good.
A
[EMAIL PROTECTED] (Rosario Colica \(XX/MCI\)) wrote:
All,
I am wondering if you can help.
I need to find the ECCN coding for the DB in order to be able to export of
our products with the dB included.
People have asked this about Mozilla, with the following answer:
After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (Andy Shellam)
belched out:
Is there an SQL command supported by Postgres to return a list of tables in a
database?
Yes, it's called SELECT.
There is a standard schema called INFORMATION_SCHEMA, which contains a
variety of relevant
Clinging to sanity, [EMAIL PROTECTED] (Louis Gonzales) mumbled into her beard:
Hey Jim, Thanks again for the pointer to this. I've already
compiled and installed on one of the two Solaris nodes, that I
needed to. Yeah upon further reading, I can't wait for Slony-II to
come out - is there
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] (Arnau) wrote:
Which is the best filesystem in linux for postgresql? nowadays I'm
using ext3, I don't know if other filesystems like XFS, reiser... would
be better from the performance point of view.
Do you care more about
In the last exciting episode, [EMAIL PROTECTED] (Rodrigo Sakai) wrote:
I have a question about changing the port number of Databases
server. It was told to me that is a good administrative practice to
change the port number of the services, like change the 5432 to 6985
or any other number.
i have PostgreSQL 8.1.2
i want to enable autovacuum at my PostgreSQL 8.1.2 from postgresql.conf
i've got 50-60 insert and/or update queries in a second in that case
tables shouldn't be locked
does autovacuum locks tables while vacuuming?
Of course it does; any request to access a relation
This seems maybe a bit overkill to me. I think what would be more useful
is if autovacuum could execute more than one vacuum at a time, and you
could specify tables that are high priority (or possibly just say that
all tables with less than X live tuples in them are high priority). That
way a
I had to kill a vacuum in the middle with -9. I shut down and
restarted the postgres server several times after that but I am unable
to connect to the db that I was initially running vacuum on
I'm doing psql dbname and it hangs for a while. I'm still
waiting. Any ideas?
Kill -9 is distinctly
What are the correct steps to move an database and from an server
running postgreslq 7.4.2 to another running 8.0.3?
I'll assume there are two hosts:
- db7, running 7.4.2, on port 5432, and
- db8, running 8.0.3 on port 5432.
The simplest method would be thus:
- Stop the applications
i have database with critical data (such patient information)
how can i protect my database from root access
because this host in company can access with root from many person
(person who manage some service application on host but must not
access this patient information)
The only way to be
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED]
(Joshua D. Drake) transmitted:
FM wrote:
Hello after a vacuum full analyse I received this :
WARNING: some databases have not been vacuumed in 1805294030 transactions
HINT: Better vacuum them within 342189617
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (hellz waren) would
write:
we are designing a heavy duty database in pgsql that
expects to grow at an average of 100 MB spread over
tables of 250 tables.
We require always on database (24 X 7) database. And
if one fails, the other
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] wrote:
I am about to upgrade from 7.3.4 to 8.0.3, and I read that using a DB
replication tool is a good way to go about it.
Replication is useful for this purpose if it helps you cut down on the
time the transition takes.
If the
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Michael Kichanov)
would write:
I wish to realize incremental backup, i.e. to dump only those tables
which have changed from last backup.
1q. How i can solve this task with internal postgres tools?
2q. How I can to find out timestamp
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Alvaro Herrera)
wrote:
On Tue, May 03, 2005 at 06:17:31PM +0200, Stephen Kennedy wrote:
An ex-workmate had forwarded his mail to our group so we could deal with
work-related stuff, and so we received all of his
mailing list
Quoth [EMAIL PROTECTED] (dedy):
Hiii alll,
I would like to ask, does pl/sql in oracle is same with the pl/sql in
postgreSQL
They are similar, though are certainly not identical.
--
cbbrowne,@,gmail.com
http://linuxdatabases.info/info/languages.html
FLORIDA: We've been Gored by the bull of
In the last exciting episode, [EMAIL PROTECTED] (Michael Fuhr) wrote:
On Sat, Apr 23, 2005 at 10:58:46AM -0500, Thomas F.O'Connell wrote:
It is generally not recommended that you kill processes with anything
stronger than HUP, which is (I believe) what kill sends by default.
kill usually
Oops! [EMAIL PROTECTED] was seen spray-painting on a wall:
I want to kown if the Postgres can support High Available(HA) in
verson 8.
We're running some PostgreSQL 7.4 instances on the IBM HACMP system
for AIX.
That being readily supportible, I can't readily conceive of a reason
why PostgreSQL
Martha Stewart called it a Good Thing when pgman@candle.pha.pa.us (Bruce
Momjian) wrote:
Wow, nice analysis. Should this be in our documentation somewhere?
Suggest a suitable section and I'd be more than happy to send in a
patch adding this in. The only place I see pgcrypto referred to
(which
In the last exciting episode, [EMAIL PROTECTED] (Joseph Brenner) wrote:
I was talking to someone just recently who was saying that they
were thinking about going with Oracle rather than Postgresql
because Oracle has a their story in place about how to do
disk encryption. So I am of course,
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Tsirkin Evgeny)
wrote:
Hi list!
We are using currently postgresql 7.3.4 havily and planning an upgrade.
our choices are either 7.4.x which comes with distribution (suse) or 8.0.1 .
We can allow our selfs some testing time and
After a long battle with technology, [EMAIL PROTECTED] (prakash sompura), an
earthling, wrote:
Can any one tell me how do I replicate my PostgreSql database from
one server to another server?
One method involves using pg_dump to dump the state out, and load it
onto the other server. Certainly
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] (David B) wrote:
Environment. PG v8. (Opteron 2CPU. Raid 5 disks 1TB. 12GB Ram)
Environment would be one master feeding 3 slaves. Similar configs.
New transactions coming into master. Cust Service Reps using that box.
Analysis being
After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (Steve Crawford)
belched out:
On Thursday 17 March 2005 3:51 pm, Tom Lane wrote:
Steve Crawford [EMAIL PROTECTED] writes:
My autovacuum config is running and I do see regular periodic
vacuums of these pg_ tables but still they
You could add this into whatever script starts up pg_ctl, but only if
you decide to use PostgreSQL rather than Postgre.
Could any one tell me how can I implement this in Postgre. Is there
any concept like Scheduled Jobs in Postgre. If so pls. provide me
with related informations or the links
[EMAIL PROTECTED] (Aravindhan G.D) wrote:
I need to do some user defined jobs when ever the Postgre server
gets restarted. These tasks should be automated one i.e) When ever I
restart the server the PL/SQL functions I have defined should be
executed automatically without my intervention. This
Solaris is highly attuned to running threaded applications, and
PostgreSQL is not that sort of application. So you're definitely not
playing to Solaris' strengths.
Solaris is one of the platforms that has been noted for suffering from
context switch slowdowns when hit with a lot of concurrent
Clinging to sanity, [EMAIL PROTECTED] (Dick Davies) mumbled into her beard:
Is there a neat way to clean out a database via SQL commands?
i.e. get rid of tables, sequences, integers, etc.
At present I'm using dropdb/createdb, but thats' far from ideal
and I think it's causing postgres to do
The world rejoiced as [EMAIL PROTECTED] (Fred Blaise) wrote:
Hello
I am running postgres 7.4.6 on 2 BSDi boxes. One is live, the other one
is a failover. I would like to implement a master-slave replication
process.
I believe replication has been included in the base package since 7.3.x.
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (M.V.
Jaga Mohan) transmitted:
I am using PgSQL 7.3 for my Application. My problem how can I scale
my database ? I mean how many records I can have in my database.
That depends mainly on how much disk space you have. If
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] (Goulet, Dick)
wrote:
You may well be on the development team, but you are wrong for
one very important reason. If the Postgresql executables are owned by
root they execute with the priviledges of root.
Methinks you may not
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED]
(Tomeh, Husam) transmitted:
I've seen book that prefer installing PostgreSQL as root and another one
recommends otherwise by first creating a postgres account and then
installing it as postgres. In the Oracle world, you
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (Devi
Munandar) transmitted:
I want to Install Slony-I 1.0.5 on my machine i386, but my
postgresql version is 7.3.2 running on OpenBSD3.4 Operating System,
so does Slony-I 1.0.5 support to postgresql 7.3.2?, because i
In the last exciting episode, [EMAIL PROTECTED] (Gourish Singbal) wrote:
Whats the Best plan to take Backups for Postgres 7.4.5 database
considering the database is 24/7 and transaction based.
Well, you can take a pg_dump to get the state of the system at a point
in time. That's very easy,
In the last exciting episode, [EMAIL PROTECTED] (David F. Skoll) wrote:
Does anyone run a very busy PostgreSQL datatabase, with lots of read
and write operations that run 24x7? (We're talking on the
neighbourhood of 40 to 60 queries/second, with probably 5% to 10% of
them being INSERT or
The world rejoiced as [EMAIL PROTECTED] (Bryan Biggers) wrote:
Can anyone tell me what the data file names with the .1 .2 .3
etc. extensions are? Are these undo versions of my tables or
something? I need to recover some disk space and I'm wondering if I
need them. Here is an example...
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Sharon Schooley) would
write:
We are looking for a 24/7 PostgreSQL solution. I've read some
postings and information on various solutions including Taygeta,
pgpool, and Mammoth PostgreSQL with Heartbeat. If there are any
users of
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Igor Maciel Macaubas)
would write:
Heather, I might be able to do it. Let me check .. I can buy a cheap
RAID IDE controller and try to mount everything as one.
You'd be about as well off, if you're running Linux, to use the md
RAID
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (k b) wrote:
Hello.
I have a slightly off topic question.
Is it possible to set up replication between a mysql
3.23.56 server and a postgresql 7.2.4 server without
any extra software in between?
i am primarily interested in
[EMAIL PROTECTED] (Simon Riggs) wrote:
Proactive, planned maintenance is more manageable than sudden,
grinding failure when you're at home in bed. Make sure your manager
is part of the call-out plan, thats usually a good way to make them
care about maintenance.
And regular maintenance allows
After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (S. C.) belched out:
We have a postgres 7.4 database which never vacuum for 4 months. I try to
vacuum one time. But my manager can't bear the low performance of website. So
I had to kill the vacuum before it finished. Is it ok for a
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Naomi Walker) would write:
Anything would plain text would be a problem. Isnt .pgpass plain
text?
Yes, it's plain text. How do you propose to improve on that?
At _some_ point, there has GOT to be a password in plain text form
that
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Sandro Garoffolo) wrote:
One question , if you set access to server with password in
pg_hba.conf how can you pass the apssword in the script?
You don't have to if you put it in $HOME/.pgpass; see the
documentation for the format of
Quoth Mario Thomas [EMAIL PROTECTED]:
We have a server in our datacentre running PostgreSQL 7.2 with about 50
databases set up (for different customers). We have just commissioned a
much better specified server which is running PostgreSQL 7.4.
We need to migrate the databases from 7.2 to 7.4.
[EMAIL PROTECTED] (Enrique Arizón) commented:
Now that CA has open sourced Ingres what future do
you guess to Postgresql and MySQL?
Don't missunderstand me, I have been using Postgresql for more than
3 years and developing apps against it and all I got is possitive
impressions, but
Quoth [EMAIL PROTECTED] (slane):
Hello all:
I am upgrading a web application from postgres 7.1.2 to 7.4.3 (too long in
coming to that point, I know).
I have sifted through the history files and identified a restricted number
of changes that potentially impact the app, a few of which I don¹t
The world rejoiced as [EMAIL PROTECTED] (Rodrigo Botana) wrote:
There is any way to have a replication (master - slave) whithout
install anything on the slave computer. I ask this because i would
like to have my website (that don't have any replication service
avaliable) with the same
Oops! [EMAIL PROTECTED] (Gaetano Mendola) was seen spray-painting on a wall:
| You are aware that there is a slony mailing list at
| http://gborg.postgresql.org/mailman/listinfo/slony1-general right? Does
| that not serve your purposes?
I knew it, some times I'm in IRC too, but I feel better
After a long battle with technology, [EMAIL PROTECTED] (Matt Browne), an earthling,
wrote:
I apologise in advance if any of my questions are in a FAQ somewhere - I
haven't seen them...
Does anyone know when (if ever) replication support will be added to the
main PostgreSQL codebase? Is there
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] (Bender, Cheryl) wrote:
Just wondering--is it possible to dump on a temporary table?
The temp table is only visible inside the context of the transaction
under which it was created.
A pg_dump session will create an independent
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] wrote:
Hello
i have:
create table student(
id SERIAL NOT NULL,
name VARCHAR(35) NOT NULL,
primary key (id)
);
and when i try to insert like this:
insert into student (name) values('me');
i
In the last exciting episode, [EMAIL PROTECTED] (Mr. Darshan Patel) wrote:
I had install postgresql server on two different port : default(5432) and
other(5545), now I have to setup replication/mirror between them So what are
the steps/setup procedure.
That presumably depends on which
[EMAIL PROTECTED] (Vasil Kolev) wrote:
I'm working on a system that has 2 servers with postgresql, and a FC
shared storage between them, where the database is stored. After
some weeks of using google and reading lists, I've come to the
conclusion, that there is no way (using F(L)OSS tools) to
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Frank Smith) would write:
Hi
ID:7
I am running PostgreSQL 7.2.2 on Red Hat 9 and I am suffering a
growing performance problem. The problem shows through a slowing of
queries and an increase in the system CPU usage. Queries that
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Paul Gimpelj) wrote:
I have redhat 7.3 and postgres 7.2
Is there a way to have 7.4 installed together with postgres 7.2 ? and both running
at the same time,
with of course different data directories.
should i use the generic
After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (Tom Lane) belched out:
Bill Chandler [EMAIL PROTECTED] writes:
LOG: invalid entry in pg_hba.conf file at line 60,
token 255.255.255.255
I have found that if I change this value to anything
other than 255.255.255.255 (e.g.
Oops! [EMAIL PROTECTED] was seen spray-painting on a wall:
Hello list,
I know this is a complicated issue, but I'll throw it out there...
Our DB box has 3GB of ram - which is supposed to be used by
postgres. Whenever I use top, it only shows about 800MB being
used with 2.2GB free. What can
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Peter Eisentraut) wrote:
Bradley Kieser wrote:
I desperately need to set up a real time replication of several
databases (for failover) between two servers. Last time I looked at
the PG replication it wasn't yet production level. I
[EMAIL PROTECTED] (Josh Berkus) wrote:
Well, as I said, that's why I was asking - I'm willing to give it a go
if nobody can prove me wrong. :)
Why not? If you have time?
True enough.
I thought you knew - OCFS, OCFS-Tools and OCFSv2 have not only been
open- source for quite a while now -
[EMAIL PROTECTED] (Jaime Casanova) asked:
so, the real question is what is the best filesystem for optimal speed
in postgresql?
The smart-alec answer would be... Veritas, of course!
But seriously, it depends on many factors you have not provided
information about.
- Different operating
After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (Jaime Casanova) belched
out:
Can you tell me (or at least guide me to a palce where i can find the
answer) what are the benefits of filesystems over raw devices?
For PostgreSQL, filesystems have the merit that you can actually use
After a long battle with technology, [EMAIL PROTECTED] (Andrew Biagioni), an
earthling, wrote:
Can anyone recommend an editor (windows OR linux) for writing plpgsql
code, that might be friendlier than a standard text editor?
Nice features I can think of might be:
- smart tabbing (1 tab = N
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (Bradley
Kieser) transmitted:
I think as far as PG storage goes you're really on a losing streak
here because PG clustering really isn't going to support this across
multiple servers. We're not even close to the mark as
Quoth [EMAIL PROTECTED] (Goulet, Dick):
Comparing a MySql upgrade to anything else is comparing apples to
eggplants. Their not even in the same group. mySql likes to leave
their datafiles alone making all of their changes in the binaries.
Now while that is good from an upgrade standpoint,
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Jodi Kanter) wrote:
Do constraints effect performance significantly?
They would be expected to provide a significant enhancement to
performance over:
a) Firing triggers,
b) Firing rules, and
c) Forcing the application to validate
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] (Palle Girgensohn) wrote:
We use postgresql for rather large databases. For a typical
installation, a pg_restore takes a couple of hours, at least (the
dumpfiles are usually 2-4
gigabytes or so, including BLOBs). The machines are
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Ed Wong) wrote:
I am an oracle dba and new to postgresql. Could you tell me what is
the best postgres book out there to start with? I am looking for a
book which is sort of a complete reference including some dba chapters
as
In the last exciting episode, [EMAIL PROTECTED] (Edoardo Ceccarelli) wrote:
Yes, you are right but it wasn't the case this time, I have run the
explain plenty of times with same results. I think that the reason
was that I made a simple VACUUM, after a VACUUM FULL ANALYZE (1h!!)
things are ok
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Iain) would write:
I'd like to know more about the possibility of plain vacuums harming
performance. This is the first I've heard of it. Vacuum full is not always
an option in a production environment.
There certainly are known cases
... other files omitted ...
That can diminish how much is in the everything that needs to be
backed up...
--
let name=cbbrowne and tld=libertyrms.info in String.concat @ [name;tld];;
http://dev6.int.libertyrms.com/
Christopher Browne
(416) 646 3304 x124 (land)
---(end
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (John Siracusa) wrote:
The docs say:
Clustering is a one-time operation: when the table is subsequently
updated, the changes are not clustered. That is, no attempt is made
to store new or updated rows according to their index
a 'clone,' now
called MSMQ. Apparently pretty good stuff, where applicable...
--
let name=cbbrowne and tld=libertyrms.info in String.concat @ [name;tld];;
http://dev6.int.libertyrms.com/
Christopher Browne
(416) 646 3304 x124 (land)
---(end of broadcast
see that...
--
let name=cbbrowne and tld=libertyrms.info in String.concat @ [name;tld];;
http://dev6.int.libertyrms.com/
Christopher Browne
(416) 646 3304 x124 (land)
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ
After a long battle with technology, [EMAIL PROTECTED] (Renney Thomas), an earthling,
wrote:
Has anyone any experience with PGSQL 7.x and implenting the FTC
do-not-call list - which is about 50 million 10 digit N. American
phone numbers? If so what structures have you used and what have you
];;
http://dev6.int.libertyrms.com/
Christopher Browne
(416) 646 3304 x124 (land)
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (ow) wrote:
--- Tom Lane [EMAIL PROTECTED] wrote:
Actually you can only have 4 billion SQL commands per xid, because the
CommandId datatype is also just 32 bits. I've never heard of anyone
running into that limit, though.
Perhaps
: posix
gcc version 3.2
--
(format nil [EMAIL PROTECTED] cbbrowne libertyrms.info)
http://dev6.int.libertyrms.com/
Christopher Browne
(416) 646 3304 x124 (land)
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
In the last exciting episode, Cristian Veronesi [EMAIL PROTECTED] wrote:
Hello, my company is starting to propose postgresql-based solutions
to our clients. Our recommended operating system is SuSE
Linux. Which disk architecture should we recommend for postgresql
servers? I was thinking about
Cris Carampa [EMAIL PROTECTED] writes:
Christopher Browne wrote:
The best performance results I have seen on Linux systems have
involved the use of JFS. I found XFS to be a little slower, and it
has the distinct demerit that it is not in the 'official' kernel tree
yet, thereby meaning
In the last exciting episode, [EMAIL PROTECTED] (Andrew Sullivan) wrote:
On Tue, Nov 11, 2003 at 01:52:26PM -0700, scott.marlowe wrote:
I thought .org and .info were being run on postgresql/solaris?
They are. I'd happily dump the Solaris use overboard, however, if it
weren't for all the
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (exciteworks
hosting) transmitted:
Is there an easy way to copy all DBs and users on a server to another
server?
I need to get an exact duplicate.
How exact is exact?
One notion of exact would involve stopping the
is described in the documentation tree thus:
http://www.postgresql.org/docs/7.2/interactive/populate.html
--
output = reverse(ofni.smrytrebil @ enworbbc)
http://dev6.int.libertyrms.com/
Christopher Browne
(416) 646 3304 x124 (land)
---(end of broadcast
Quoth [EMAIL PROTECTED] (Stephen Frost):
* Christopher Browne ([EMAIL PROTECTED]) wrote:
On one of our test servers, I set fsync=false, and a test load's
load time dropped from about 90 minutes to 3 minutes. (It was
REALLY update heavy, with huge numbers of tiny transactions.)
Which
.int.libertyrms.com/
Christopher Browne
(416) 646 3304 x124 (land)
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Geoffrey) wrote:
I've got a client who is following my suggestion that they replace a
set of excel spreadsheets with a database solution. They are
looking at two proposals, postgresql solution or an Access solution.
The
is not quite the same
as never.
--
output = (cbbrowne @ libertyrms.info)
http://dev6.int.libertyrms.com/
Christopher Browne
(416) 646 3304 x124 (land)
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (Oliver
Elphick) transmitted:
On Mon, 2003-10-13 at 11:30, Szabó Péter wrote:
Hi!
I have a lock problem. If i lock a record with SELECT FOR UPDATE, than
i try to lock again, the process just wait until the record free.
In the last exciting episode, [EMAIL PROTECTED] (Chris White (cjwhite)) wrote:
BTW, the connection I shutdown, had not read, written or deleted any
large objects. It had read and written to other tables. This is causing
me concern as I am using a thread pool to provide access to the data in
In an attempt to throw the authorities off his trail, Jeff Boes [EMAIL PROTECTED]
transmitted:
I've only just now noticed that CREATE INDEX accepts a 'WHERE'
clause. This is used to create something called a partial index.
Hmm, ever being one who sees the world as made of nails when first
[EMAIL PROTECTED] (John Allgood) writes:
I am looking for information on what operating systems and
filesystems people are running postgresql on. I have read so much on
this I decided to get some input from other people. I at first was
leaning toward FreeBSD and using its filesystem.
ofni.smrytrebil @ enworbbc))
http://dev6.int.libertyrms.com/
Christopher Browne
(416) 646 3304 x124 (land)
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Ravi T Ramachandra)
wrote:
I recently setup postgres on a Linux box with 4GB Ram and 2.5 GHz
processor. We have created a database with 1.5 million rows in a
table. When we try to select rows from the table, it is taking
1 - 100 of 105 matches
Mail list logo