On Wed, Apr 27, 2011 at 01:29:10PM -0700, ramon cruel wrote:
> Please!!!
http://mail.postgresql.org/mj/mj_wwwusr/domain=postgresql.org?func=lists-long-full&extra=pgsql-admin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgre
On Wed, Apr 27, 2011 at 6:26 PM, Scott Marlowe wrote:
> I had a similar problem about a year ago, The parent table had about
> 1.5B rows each with a unique ID from a bigserial. My approach was to
> create all the child tables needed for the past and the next month or
> so. Then, I simple did so
I had a similar problem about a year ago, The parent table had about
1.5B rows each with a unique ID from a bigserial. My approach was to
create all the child tables needed for the past and the next month or
so. Then, I simple did something like:
begin;
insert into table select * from only tabl
On Wed, Apr 27, 2011 at 04:17:16PM -0400, Mark Stosberg wrote:
> On 04/27/2011 10:48 AM, Mark Stosberg wrote:
> >
> > Hello,
> >
> > I'm working on moving a table with over 30 million to rows to be
> > partitioned. The table seeing several inserts per second. It's
> > essentially an activity log
Please!!!
On 04/27/2011 10:48 AM, Mark Stosberg wrote:
>
> Hello,
>
> I'm working on moving a table with over 30 million to rows to be
> partitioned. The table seeing several inserts per second. It's
> essentially an activity log that only sees insert activity and is
> lightly used for reporting, such that
"Fred Parkinson" writes:
> Was there some way to tell from the documentation that createdb is to run
> from the shell while CREATE DATABASE is run from the psql prompt?
The reference section of the manual documents the former under "Client
Applications" and the latter under "SQL Commands".
"Fred Parkinson" wrote:
> Was there some way to tell from the documentation that createdb is
> to run from the shell while CREATE DATABASE is run from the psql
> prompt?
One is in the "PostgreSQL Client Applications" section, along with
psql and pg_dump. The other is in the "SQL Commands" sec
Right you are! 'CREATE DATABASE' worked (started psql with the postgres
database) where createdb didn't.
Was there some way to tell from the documentation that createdb is to run from
the shell while CREATE DATABASE is run from the psql prompt? I assumed all
database-related commands are ru
Mark,
Comments inline below for items 2 and 3. What you are planning should work
like a charm.
Bob Lunney
--- On Wed, 4/27/11, Mark Stosberg wrote:
> From: Mark Stosberg
> Subject: [ADMIN] best practice for moving millions of rows to child table
> when setting up partitioning?
> To: pgsql-
> Similar posting on partition table, take this inputs before going
> forward with partition table.
>
> http://archives.postgresql.org/pgsql-general/2011-04/msg00808.php
>
> Best solution given by Greg Smith as well Vick.
Thanks for the replies.
Today I reviewed the section on partitioning fro
"Fred Parkinson" wrote:
> I tried using the database 'postgres' which seems to be created
> during the install:
> psql postgres, which takes me to a psql prompt. However, the
> command createdb -T DEFAULT "timecard" now results in the error
> "syntax error at or neat "createdb" with a carat poi
Folks
As I have been unable to install pgadmin3 on my OpenSUSE Linux 10 box
(erroneously described as 11.2 in the request for help post, that was useless),
I have decided to use psql since it seems to be my only option.
However, I have no database as yet, and when I type in a console 'psql' I
Hi Mark,
Similar posting on partition table, take this inputs before going forward
with partition table.
http://archives.postgresql.org/pgsql-general/2011-04/msg00808.php
Best solution given by Greg Smith as well Vick.
Best Regards,
Raghavendra
EnterpriseDB Corporation
The Enterprise Postgres C
Hello,
I'm working on moving a table with over 30 million to rows to be
partitioned. The table seeing several inserts per second. It's
essentially an activity log that only sees insert activity and is
lightly used for reporting, such that queries against it can safely be
disabled during a transit
Zitat von Scott Ribe :
Just had a hard crash, and pg came back looking ok. However, crash
was in the driver for the (battery-backed) RAID card, and I know for
a fact that one file that was written to the (journaled) file system
before the crash was not there after reboot. So, what steps are
Zitat von Chris Ernst :
On 04/24/2011 04:21 PM, David Hornsby wrote:
My SMB database is currently running on a HP-UX box running in a master
- slave slonyI cluster to create a hot spare database. Recently the
server has be getting hammered and we are consistently hitting our max
db connections.
17 matches
Mail list logo
