On Mon, Aug 16, 2010 at 4:01 PM, Tom Lane wrote:
> Greg Smith 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, this is much harder to get
>> worki
On Sun, Jan 25, 2009 at 1:47 PM, Ezra Taylor 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
be, for a totally wri
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 specif
The world rejoiced as [EMAIL PROTECTED] (August Zajonc) wrote:
> Ted Byers wrote:
>
> [snip]
>> It is outrageously unethical, IMHO, for a programmer, or group thereof,
>> to refuse to fix a problem that has arisen from how their targetted
>> users use their application.
>
> Let's save the determin
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 diffe
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
[EMAIL PROTECTED] (Amadeus Zilfinski) wrote:
> My only real issue with PostgresQL is that it is a client/server
> database, that is not embeddable. If it was embeddable then I could
> use it with no issue, and would in fact rather use it. I recall some
> people are working on that, but don't have a
After a long battle with technology, [EMAIL PROTECTED] ("Benjamin Krajmalnik"),
an earthling, wrote:
> Any assistance or guidance will be deeply appreciated. I am pulling
> hairs on this one.
It needs to be vacuumed a lot more aggressively. If you're using
pg_autovacuum, the defaults seem to be
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 app
[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 go
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] ("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:
http://www.heck
In the last exciting episode, [EMAIL PROTECTED] (Pierre LEBRECH) wrote:
> Thanks for any suggestions and explanations.
A third possibility would be PITR, new in version 8, if the point is
to have recovery from big failure. You'd periodically copy the whole
DB, and continually copy WAL files acros
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 releva
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 perfo
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 numb
> 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 rela
> 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
> w
> 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 di
> 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 access
> On Thu, Nov 17, 2005 at 02:04:42PM -0500, Chris Browne wrote:
>> If your OS or disk hardware supports some sort of "snapshotting"
>> technology, so that you can grab a copy of the whole thing as an
>> instant atomic operation, that provides a way to grab a copy while
>> postmaster is running. If
> 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 t
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 t
After a long battle with technology, [EMAIL PROTECTED], an earthling, wrote:
> I need a reliable way to determine the overall size of our database.
> Recently, I started using the database_size() function from the dbsize
> contrib.
>
> Everything seems to work great until I need to delete records.
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 ot
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 da
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 timest
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 l
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 b
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 u
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 Postgre
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 m
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. Certainl
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
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 be
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 l
[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.
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 tra
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 t
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
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. I
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] ("Goulet, Dick")
wrote:
> Well, thanks for the leeway, but getting one's nose rubbed in things for
> good and bad comes with the turf. If there's one thing I've learned
> about software over the years it's that there are many ways to sk
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, yo
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
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
Well, you can take a pg_dump to get the state of the system at a point
in time. That's very easy.
But you really need to specify your 'disaster modelling' and recovery
requirements in _much_ greater detail. It may be that in order to
keep recovery time down, you'll need to use a replication syst
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, al
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...
> -r
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 o
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"
RAI
[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 al
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
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 f
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 o
After a long battle with technology, [EMAIL PROTECTED] (kris pal), an earthling, wrote:
>
>
>>
>>> 1) Can you tell me if there is any other work around to vacuum the
>>> pg_attribute system table ? Like doing it in parts so that it won't
>> >cause a high load.
>
> Chris Br
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
[EMAIL PROTECTED] ("Goulet, Dick") wrote:
> Personal opinion here: Software packages like MySql and Ingres in
> the open source world are doomed to obsolescence. Reason, they are
> released by a for profit company that is trying to play up to the
> open source market.
Seems fair.
> In MySql's ca
[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 co
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
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 in
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 bet
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
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
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 tra
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 r
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. Queri
[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)
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
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. Wha
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"
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 le
[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 whi
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
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
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
[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
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 standpoin
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] (Gorshkov) wrote:
> On March 8, 2004 09:07, Andrew Sullivan wrote:
>> On Mon, Mar 08, 2004 at 12:07:23PM +, Silvana Di Martino wrote:
>> > This seems to give to this "db encryption" issue the status of
>> > "global relevance" that wou
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] (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
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 w
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 cas
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 ar
-devel-9.24-3.i386.rpm
/usr/include/pam.h
/usr/include/pammap.h
/usr/include/pbm.h
/usr/include/pbmshhopt.h
/usr/include/pgm.h
/usr/include/pm.h
... other files omitted ...
That can diminish how much is in the "everything" that needs to be
backed up...
--
let name="cbbrowne" and t
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
t you do amounts to running
a single serial report, you surely won't 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)
--
osoft paid an Israeli company to develop 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 B
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 7: don't forget to increase your free space map settings
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
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.
>
Quoth [EMAIL PROTECTED] (ow):
> Hypothetical situation: a table containing, say, 10 billion rows is backed up
> and then restored with pg_restore. Would this lead to the transaction id
> wraparound issue since 10B rows are imported in one "batch"?
No.
Copying the 10 billion rows in only consumes
In the last exciting episode, [EMAIL PROTECTED] (Bruce Momjian) wrote:
> I would hate to be the only license that OpenBSD doesn't like. :-)
I think you haven't conversed with Theo enough [shudder...]
You wouln't want him to prefer the GPL, would you :-).
--
let name="cbbrowne" and tld="cbbrowne
[EMAIL PROTECTED] ("Ivan") wrote:
> As I am new in the world of PostgreSQL I would like to know what are
> the advantages of using it.
That cannot be evaluated in the absence of some set of metrics
indicating your preferences and needs, and which would allow comparing
PostgreSQL to some other opti
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 'of
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 a
1 - 100 of 121 matches
Mail list logo
