I think you want to look at kdb, onetick, and LIM (those are
commercial). or potentially mongoDB where you could probably store a
compressed ts directly in the db if you want.
If you're not going to store each observation as a row, then why use a
db at all. why not stick to flat files?
-Whit
I am in a similar situation described by this thread:
http://www.mail-archive.com/pgsql-general@postgresql.org/msg78604.html
I need to write a few xml files to be consumed by a vendor application
in real-time. The queue / (poll/cronjob) seems simple enough.
Before I commit I just wondered if
We have Jira + Confluence on postgres. Small site (25 users). No issues.
-Whit
On Mon, Aug 30, 2010 at 5:26 AM, Jayadevan M
jayadevan.maym...@ibsplc.com wrote:
Hello all,
Has any one worked with Jira on PostgreSQL?
We are considering Jira implementation for our organization (about 1500
Is there any easy way to get this data:
kls_dev=# select * from ary_values;
agent_name | myval
+---
a | 1
a | 2
a | 3
b | 4
b | 5
b | 6
(6 rows)
to look like this:
kls_dev=# select * from
That's exactly what I needed. Thanks very much!
-Whit
On Fri, Oct 9, 2009 at 12:29 PM, Raymond O'Donnell r...@iol.ie wrote:
On 09/10/2009 17:17, Whit Armstrong wrote:
Is there any easy way to get this data:
kls_dev=# select * from ary_values;
agent_name | myval
I have a simple example copied from the 8.3 manual on partitioning
(http://www.postgresql.org/docs/8.3/interactive/ddl-partitioning.html).
My question is, if you create a serial type in the parent table which
is meant to be the primary key across all the partitions, how does one
guarantee
is that there is no explicit constraint
in the database that prevents duplicate id's from being created, and
I'm not sure how the rails app would react if for whatever reason
duplicate id keys wound up in the table.
Any suggestions?
Thanks,
Whit
On Sun, Jun 28, 2009 at 1:27 PM, Tom Lanet...@sss.pgh.pa.us wrote:
Whit
I needed to write a product aggregate function, and just happened to
find this example in the nodes to the 8.0 manual:
Ansis ansis_no_ AT inbox.lv13 Jan 2006 16:41:05
An aggregate multiplication function, an analog of sum (the same
should be defined also for other numeric types):
CREATE OR
I had a few queries that were fired from pgAdmin, but failed to stop
running after I killed the GUI.
I tried to stop the queries by killing the pid (of the process running
the query, not the pid of the server) from the linux command line, and
much to my surprise, the whole database went down and
Thanks, Tom.
Lesson learned.
Are there any integrity checks I need to run on the db after this type
of crash and recovery, or is vacuum --all good enough?
-Whit
On Wed, Jun 17, 2009 at 11:19 AM, Tom Lanet...@sss.pgh.pa.us wrote:
Whit Armstrong armstrong.w...@gmail.com writes:
I had a few
is uninitialized --- fixing
WARNING: relation balances_primary page 1883405 is uninitialized --- fixing
WARNING: relation balances_primary page 1883406 is uninitialized --- fixing
-Whit
On Wed, Jun 17, 2009 at 12:09 PM, Tom Lanet...@sss.pgh.pa.us wrote:
Whit Armstrong armstrong.w...@gmail.com writes
Does anyone know why I get an unknown relation error when I query for
relation size?
kls=# select tablename, pg_size_pretty(pg_relation_size(tablename))
from pg_tables where schemaname = 'econ' order by tablename;
ERROR: relation series_info does not exist
kls=#
Is there a better way to do this
2009, om 13:17 heeft Whit Armstrong het volgende geschreven:
Does anyone know why I get an unknown relation error when I query for
relation size?
kls=# select tablename, pg_size_pretty(pg_relation_size(tablename))
from pg_tables where schemaname = 'econ' order by tablename;
ERROR: relation
anyone know a way to get nagios to monitor the number of postgres connections?
Thanks,
Whit
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I have a 300GB database, and I would like to look at partitioning as a
possible way to speed it up a bit.
I see the partitioning examples from the documentation:
http://www.postgresql.org/docs/8.3/static/ddl-partitioning.html
Is anyone aware of additional examples or tutorials on partitioning?
Is it possible to find out the OID types of the columns of a table
using the information schema?
I see that I can get the character names of the types using this query:
select * from information_schema.columns where table_name = 'my_table';
but I don't see a way to find the actual OID types of
, there is no example that uses a schema + tablename.
-Whit
On Mon, Apr 27, 2009 at 11:53 AM, Whit Armstrong
armstrong.w...@gmail.com wrote:
Thanks, Tom.
So, it's more like this:
select attname, atttypid from pg_attribute where attrelid = attrelid
of my table;
hmm, so how do I find the attrelid of my table
a little confused about the
internals.
Thanks,
Whit
On Mon, Apr 27, 2009 at 12:29 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Whit Armstrong armstrong.w...@gmail.com writes:
However, there is no example that uses a schema + tablename.
If you're into masochism you can do that with a join of pg_class
ok, got it.
thanks for the clarification and the hand holding.
-Whit
On Mon, Apr 27, 2009 at 1:09 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Whit Armstrong armstrong.w...@gmail.com writes:
Am I misinterpreting this documentation? Are there cases in which the
OID's of two tables will collide
how does one determine whether libpq is sending an int64 or a double?
I see all of the #ifdefs in the source:
#ifdef HAVE_INT64_TIMESTAMP
static int64 time2t(const int hour, const int min, const int sec,
const fsec_t fsec);
#else
static double time2t(const int hour, const int min, const int sec,
Thanks, Tom.
That's just what I needed.
-Whit
On Mon, Mar 23, 2009 at 7:15 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Whit Armstrong armstrong.w...@gmail.com writes:
but it is still unclear (at least to me) how to determine as the
client whether the server has been compiled
21 matches
Mail list logo