bakkiya writes:
> We are having a partition table and we are querying some rows in the
> partition.
> select * from events where
>events.evt_time >= '2010-11-29 00:00:00'
> AND events.evt_time <= '2010-11-30 23:59:59'
> While this query is in running state, I am issuing a drop stat
"Lello, Nick" wrote:
> What is considered the best filesystem to use for postgres data
> stores ?
I held off for a bit to see if someone else would jump in with a
comparison of filesystems, but so far nobody has taken the bait.
The reason I held off is that the only reasonable answer I can th
On Wed, Dec 01, 2010 at 09:54:11AM -0600, Kevin Grittner wrote:
> "Lello, Nick" wrote:
>
> > What is considered the best filesystem to use for postgres data
> > stores ?
>
Greg dedicates a chapter in his book on the topic:
https://www.packtpub.com/postgresql-9-0-high-performance/book
--
Sen
On 12/1/2010 7:54 AM, Kevin Grittner wrote:
Your RAID configuration and controllers will likely make a bigger
difference than your filesystem choices. Be sure to get good RAID
controllers with battery-backed (BBU) cache, configured for
write-back.
I agree that st
On 12/1/10 7:54 AM, Kevin Grittner wrote:
"Lello, Nick" wrote:
What is considered the best filesystem to use for postgres data
stores ?
I held off for a bit to see if someone else would jump in with a
comparison of filesystems, but so far nobody has taken the bait.
The reason I held off is t
OK, weighing in here...
We use ZFS on Solaris for our data stores. Can't beat ZFS for its failsafe
features, filesystem portability, etc.
Having said that, there is that school of thought which would hold that
journaling may not be all that indicated anymore, given the quality of recovery
Hello.
I have a not bootable Windows Server with Postgres 8.1; now I am trying to
recover it but as I can't boot the windows; I can't start the postgres service
and I can't do a "Backup"
So; I only have the postgres directory on my hands. I decide to install the
same database version in anothe
nick.le...@rentrakmail.com ("Lello, Nick") writes:
> What is considered the best filesystem to use for postgres data stores ?
What is your metric for "best"?
Several are plausible:
- Fastest, for write workload (read performance doesn't usually vary
much based on filesystem)
- Fastest, for re
Lou Picciano writes:
> We use ZFS on Solaris for our data stores. Can't beat ZFS for its failsafe
> features, filesystem portability, etc.
> Having said that, there is that school of thought which would hold that
> journaling may not be all that indicated anymore, given the quality of
> recov
About a month ago I upgraded five Linux (CentOS 4.4) DB boxes (for load
balancing) from 8.3.0 to 9.0.1 in order to use replication, which I
needed for a new web/DB application. The replication configuration went
well, and all the four "hot_standby" servers are (streaming) replicating
just fine
Hello.
I have a not bootable Windows Server with Postgres 8.1, now I am trying to
recover it but as I can't boot the windows, I can't start the postgres
service and I can't do a "Backup"
So, I only have the postgres directory on my hands. I decide to install the
same database version in another c
On 02/12/10 01:11, Anibal David Acosta wrote:
> So, I don't know how to recover the database from the data directory of a
> windows postgres 8.1 installation.
You'll need PostgreSQL 8.1 for Windows. This appears to have been
removed from the FTP site for the well-intentioned reason that, on
Windo
12 matches
Mail list logo
