I'm new to PosgtreSQL, a veteran with Informix. We are considering a migration.
In Informix, it is recommended to create explicit named indexes on
columns for primary and foreign keys prior to creating the
constraints. Otherwise, the server create the indexes for you with
meaningless names. This i
Once again, I'm trying to translate my knowledge of Informix to
PostgreSQL. I tried the manual and Google, but could not find anything
relevant.
Informix keeps transaction logs in a dedicated, pre-allocated disk
area that, until very recent versions, could not grow dynamically. It
is the DBA's res
> Is there any way to query the database to identify what the current
> connections are (connections, sessions, or whatever you want to call them)?
select * from pg_stat_activity;
---(end of broadcast)---
TIP 6: explain analyze is your friend
> > Is this an FAQ?
>
> Yes, it gets asked a lot.
>
> Is it in the FAQ? Don't know.
In the FAQ? No
In the Manual? Yes
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your
On Nov 25, 2007 3:32 PM, Dave Potts <[EMAIL PROTECTED]> wrote:
> Is there such a thing as an opensource schema printer for postgres ?
http://schemaspy.sourceforge.net/
Creates nice html pages and graphics for many database flavors. Uses Java/JDBC.
---(end of broadcast)---
> Someone is working on extending the current system to allow read-only
> queries on a standby server [1], thus making it a "hot standby", but
> this feature apparently won't be included until 8.4 [2].
My 2 cents...
I would rather see someone working on true synchronous replication,
rather than a
> Alvaro Herrera wrote:
> > Glyn Astill wrote:
> >> Thanks everyone for your replies. EnterpriseDB looks like the way to
> >> go if we want good replication.
> >
> > Sorry, this makes no sense to me -- EnterpriseDB has no replication
> > solution that I know of.
>
> Yeah, there is:
>
> http://www.e
> > Yes, but I'd like something better than "near real time" as the above
> > page describes. Or maybe someone could clarify that Besides,
> > EnterpriseDB does not save me enough money. In my current commercial
> > DB, if a transaction is committed on the master, it is guaranteed to
> > be com
On Nov 28, 2007 9:32 AM, Chad Hendren <[EMAIL PROTECTED]> wrote:
> I have a large OEM customer (one of the top 8 for Sun worldwide) that is
> considering embedding PostgreSQL into the core of their primary product
> instead of Informix. He is trying to build his case for this change.
> Do we have
On Jan 4, 2008 8:33 AM, Magnus Hagander <[EMAIL PROTECTED]> wrote:
> On Wed, Jan 02, 2008 at 11:17:52PM -0800, Goboxe wrote:
> > Hi,
> >
> > What are required to be configured in order to send logs to
> > remote syslog server for pg running on Windows platform?
> >
> > In http://pgfouine.projects.p
10 matches
Mail list logo