> change the tablename in the CREATE and COPY commands from smsdepartments to
> departments
My backed up table called smsdepartments was created by the command below from
the database smstest, which is a backup of the database sms. The backup file
smsdepartments (a backup of the departments tabl
- "Jaume Sabater" <[EMAIL PROTECTED]> wrote:
> The guys creating the web site at the company I work for want an
> incremental search for locations. So, I need to find all locations
> that start with Uni, then Unit, then Unite, and so on. Problem is that
Correct: start or contain.
> What I do
Hello everyone!
The guys creating the web site at the company I work for want an incremental
search for locations. So, I need to find all locations that start with Uni,
then Unit, then Unite, and so on. Problem is that the tables, although
partitioned, have got several milion of tuples. Here is
On Wed, Dec 3, 2008 at 3:34 PM, AmitKumar Jain <[EMAIL PROTECTED]> wrote:
> Hi Team
>
> 1. Can we know the how much time will take ongoing vacuum process in DB?
> 2. Any benchmarking tool for vacuum process.
> 3. Can we know what exact operations has been done by Vacuum process.
> 4. I studied tha
--- On Wed, 3/12/08, Marc Fromm <[EMAIL PROTECTED]> wrote:
> From: Marc Fromm <[EMAIL PROTECTED]>
> Subject: [ADMIN] restore a table in a database
> To: "pgsql-admin@postgresql.org"
> Date: Wednesday, 3 December, 2008, 7:21 PM
> How do I restore just a table to a database? I was able to
> create
Hi Team
1. Can we know the how much time will take ongoing vacuum process in DB?
2. Any benchmarking tool for vacuum process.
3. Can we know what exact operations has been done by Vacuum process.
4. I studied that only VACUUM process doesnot lock the table but due to
it insertion in table gets
