On Thu, Dec 12, 2013 at 12:47 PM, Dev Kumkar wrote:
> + hackers
>
>
>
> On Thu, Dec 12, 2013 at 12:34 PM, Dev Kumkar wrote:
>
>> On Wed, Dec 11, 2013 at 9:47 PM, Dev Kumkar wrote:
>>
>>> Actually for searches lower will work.
>>> But the other important aspect is 'inserts' which would result 2 row
Tim Uckun wrote
> How can I drop this table and leave the sequence alone? Obviously the
> newly
> created table needs it.
You cannot. You need to put the sequence up for adoption and have the "new"
table become its parent/owner.
http://www.postgresql.org/docs/9.2/interactive/sql-altersequence.
I have a table foo. It has a serial column called "id". I execute the
following statement
ALTER TABLE table_name RENAME TO archived_table_name;
CREATE TABLE table_name (LIKE archived_table_name INCLUDING
DEFAULTS INCLUDING CONSTRAINTS INCLUDING INDEXES);
. Archieve the table
On Tue, Dec 10, 2013 at 5:57 PM, bricklen wrote:
> If you willing to install the pgstattuple[1] extension, what does the
> output say? Note, there is some overhead on larger tables (disk I/O
> primarily)
>
Yeah, this is a prod database that sees nontrivial traffic, so I'm not yet
ready to instal
On Tue, Dec 10, 2013 at 11:23 PM, Michael Paquier wrote:
> On Wed, Dec 11, 2013 at 1:17 PM, Sandeep Gupta
> wrote:
> > Hi Michael,
> >
> > I can provide the table schema and the data over which indexing almost
> > always fails with tuple not found error.
> > Would this be of help. The other is
In 1.0, we added new APIs to GTM so that vacuum can run with global
XID and snapshot. We may need more improvement to use this.
It is wonderful if Mason provides a patch to fix this.
Regards;
---
Koichi Suzuki
2013/12/11 Michael Paquier :
> On Tue, Dec 10, 2013 at 11:00 PM, Mason Sharp wrote
Hi,
I'm working on the design of a database for time series data collected
by a variety of meteorological sensors. Many sensors share the same
sampling scheme, but not all. I initially thought it would be a good
idea to have a table identifying each parameter (variable) that the
sensors report o
On Thu, Dec 12, 2013 at 2:55 PM, Mike Christensen wrote:
> Thanks! Got it working after messing around for a while..
>
>
Great! I'm glad to hear it.
> I decided to check out EF for a new project I'm working on. So far, I
> think I like NHibernate better. A lot more control, and works flawless
Thanks! Got it working after messing around for a while..
I decided to check out EF for a new project I'm working on. So far, I
think I like NHibernate better. A lot more control, and works flawlessly
with Postgres and Npgsql.
Mike
On Thu, Dec 12, 2013 at 8:34 AM, Francisco Figueiredo Jr.
Hi, Mike.
We are working to get EF6 properly supported and our master branch already
has support for it.
Unfortunately pgfoundry is down at the moment.
Please, if you can compile Npgsql from source code, please get a current
snapshot from github and give it a try: https://github.com/npgsql/Npgsql
no. use cron to run a query that does what you need.
On Wed, Dec 11, 2013 at 6:38 AM, Dev Kumkar wrote:
> How to create scheduled events in postgres simillar to whats event in
> Sybase.
> Is there any method of doing so?
>
> Also am looking at PgAgent which can create jobs but is it similar lik
On 12/12/2013 08:18 AM, Wolfgang Keller wrote:
2. Synchronous multi-master configuration
Now back to the original thread:
Knowing the number of forks/projects based on Postgres, maintaining a
list on a wiki list the one below is just easier for everybody:
http://wiki.postgresql.org/wiki/R
I should have cross-posted this to pgsql-docs from the beginning, sorry
for the mistake.
For pgsql-docs readers:
The issue is that the official documentation misleadingly omits the
existence of Postgresql-XC:
http://www.postgresql.org/docs/9.3/static/different-replication-solutions.html?
> Syn
Trying to follow the threads and other references - but I can't determine where
this patch ended up.
(http://www.postgresql.org/message-id/ca+tgmobrrrxco+t6gcqrw_djw+uf9zedwf9bejnu+rb5teb...@mail.gmail.com)
I'm trying to experiment with some new hardware - and the functionality to add
specific t
14 matches
Mail list logo
