On Thu, Jan 9, 2014 at 5:04 AM, Tom Lane wrote:
> CS DBA writes:
> > 1) \d and schema's
> > - I setup 2 schema's (sch_a and sch_b)
> > - I added both schema's to my search_path
> > - I created 2 tables: sch_a.test_tab and sch_b.test_tab
>
> > If I do a \d with no parameters I only see the first
CS DBA writes:
> 1) \d and schema's
> - I setup 2 schema's (sch_a and sch_b)
> - I added both schema's to my search_path
> - I created 2 tables: sch_a.test_tab and sch_b.test_tab
> If I do a \d with no parameters I only see the first test_tab table
> based on the order of my search_path.
> I ge
Hi All;
I recently ran into the following, any thoughts?
Thanks in advance...
1) \d and schema's
- I setup 2 schema's (sch_a and sch_b)
- I added both schema's to my search_path
- I created 2 tables: sch_a.test_tab and sch_b.test_tab
If I do a \d with no parameters I only see the first test_t
ql-general@postgresql.org
Date: 01/25/2010 09:57 PM
Subject: [GENERAL] general questions postgresql performance config
Sent by:pgsql-general-ow...@postgresql.org
Dear postgresql people,
Introduction
Today I've been given the task to proceed with my plan to use postgresql
Andy Colson wrote:
I recall seeing someplace that you can avoid WAL if you start a
transaction, then truncate the table, then start a COPY.
Is that correct? Still hold true? Would it make a lot of difference?
That is correct, still true, and can make a moderate amount of
difference if the
On 1/25/2010 8:12 PM, Craig Ringer wrote:
On 26/01/2010 12:15 AM, Dino Vliet wrote:
5) Other considerations?
Even better is to use COPY to load large chunks of data. libpq provides
access to the COPY interface if you feel like some C coding. The JDBC
driver (dev version only so far) now prov
On Mon, Jan 25, 2010 at 9:15 AM, Dino Vliet wrote:
>
> Introduction
> Today I've been given the task to proceed with my plan to use postgresql and
> other open source techniques to demonstrate to the management of my
> department the usefullness and the "cost savings" potential that lies ahead.
On 26/01/2010 12:15 AM, Dino Vliet wrote:
5) Other considerations?
To get optimal performance for bulk loading you'll want to do concurrent
data loading over several connections - up to as many as you have disk
spindles. Each connection will individually be slower, but the overall
throughp
Dear postgresql people,
Introduction
Today I've been given the task to proceed with my plan to use postgresql and
other open source techniques to demonstrate to the management of my department
the usefullness and the "cost savings" potential that lies ahead. You can guess
how excited I am r
Hi,
it's the same , try "EXPLAIN " if you are not sure.
Viktor
Dne pondělí 16 ledna 2006 18:01 Zlatko Matić napsal(a):
> Hello.
> Is it better to use A) or B) ?
>
> A)
>
> SELECT
> "public"."departments".*,
> "public"."plants".*,
> "public"."batches_microbs".*,
> "public"."results_microbs".*
Hello.
Is it better to use A) or B) ?
A)
SELECT "public"."departments".*, "public"."plants".*, "public"."batches_microbs".*, "public"."results_microbs".*FROM "public"."departments", "public"."plants", "public"."batches_microbs", "public"."results_microbs"WHERE "plants"."department"
= "depar
Calvin Wood <[EMAIL PROTECTED]> writes:
> symbolic link. But on win32, there is no equivalent. However, even under
> *nix system, I believe symbolic link can only be created for directories on
> the same hard drive. This seems less than optimal. Typically, one would
> place database files on RA
> I have gone through the documentation that come with version
> 8 beta 4 and I have a number of questions.
>
> (1) backup/restore
> I notice that in the documentation, it seems to suggest that
> an online backup, made via pg_start_backup() and
> pg_stop_backup() functions would back up all dat
Calvin Wood wrote:
Does it also mean that I must back up and restore all the databases (or
database cluster in Postgresql Speak) even if I am only interested in 1
database?
You can use pg_dump to backup individual databases (or tables etc). A
file-level backup does require all databases in one "
I have gone through the documentation that come with version 8 beta 4 and I
have a number of questions.
(1) backup/restore
I notice that in the documentation, it seems to suggest that an online
backup, made via pg_start_backup() and pg_stop_backup() functions would back
up all databases running
15 matches
Mail list logo
