but yes, I am doing all operations
connected from template1.
BR,
Thalis K.
On Tue, May 31, 2016 at 4:02 PM, David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Tue, May 31, 2016 at 9:49 AM, Thalis Kalfigkopoulos <tkalf...@gmail.com
> > wrote:
>
>> Intention: to
Intention: to drop a database and recreate it.
Expectation: the newly created db should be empty
What happens: dropping is fast, creation is slow, and when I reconnect, all
the data objects are still there.
Commands (tried both through command line with dropdb/createdb and through
psql)
On Fri, Dec 7, 2012 at 10:21 AM, Hari Babu haribabu.ko...@huawei.comwrote:
Backend processes are still running even if the postmaster got killed and
all other server processes are exited by checking the
Postmaster status.
** **
And the backend process is providing the service to
Hi all.
A tablespace is created successfully and so is a test table in it:
# CREATE TABLESPACE ts_name LOCATION '/path/to/tablespace/location';
# SET default_tablespace=ts_name;
# CREATE TABLE ts_test_table;
From the command line:
$ cd /path/to/tablespace/location
$ ls
PG_9.1_201105231
$ cd
On Fri, Nov 9, 2012 at 12:29 PM, Albe Laurenz laurenz.a...@wien.gv.atwrote:
Thalis Kalfigkopoulos wrote:
A tablespace is created successfully and so is a test table in it:
# CREATE TABLESPACE ts_name LOCATION '/path/to/tablespace/location';
# SET default_tablespace=ts_name;
# CREATE
Hi all,
I read somewhere that the following query gives a quick estimate of the #
of rows in a table regardless of the table's size (which would matter in a
simple SELECT count(*)?):
SELECT (CASE WHEN reltuples 0 THEN
pg_relation_size('mytable')/(8192*relpages/reltuples)
ELSE 0
END)::bigint AS
On Mon, Nov 5, 2012 at 7:14 PM, Lonni J Friedman netll...@gmail.com wrote:
On Mon, Nov 5, 2012 at 2:02 PM, Thalis Kalfigkopoulos
tkalf...@gmail.com wrote:
Hi all,
I read somewhere that the following query gives a quick estimate of the
# of
rows in a table regardless of the table's size
On Mon, Nov 5, 2012 at 9:04 PM, Lonni J Friedman netll...@gmail.com wrote:
On Mon, Nov 5, 2012 at 3:56 PM, Thalis Kalfigkopoulos
tkalf...@gmail.com wrote:
On Mon, Nov 5, 2012 at 7:14 PM, Lonni J Friedman netll...@gmail.com
wrote:
On Mon, Nov 5, 2012 at 2:02 PM, Thalis Kalfigkopoulos
Hi all.
From the current docs (Ch.13 on Concurreny Control):
In PostgreSQL, you can request any of the four standard transaction
isolation levels. But internally, there are only three distinct isolation
levels, which correspond to the levels Read Committed, Repeatable Read, and
Serializable.
On Sat, Nov 3, 2012 at 8:08 PM, Bob Pawley rjpaw...@shaw.ca wrote:
Hi
I have an unused computer which I am considering turning into a server to
run my Postgresql database.
Is this even possible to do?
If so, can someone suggest an open source server that is relatively easy
to set up?
Hi all,
I'd like to be able to operate LIKE using as arguments an integer and
a text value.
In postgresql 9.0 the following raises an error:
# SELECT 123 LIKE '123';
ERROR: operator does not exist: integer ~~ unknown
LINE 1: select 123 like '123'; ^
HINT: No operator matches
On Sat, Oct 20, 2012 at 8:02 AM, Raymond O'Donnell r...@iol.ie wrote:
On 20/10/2012 11:54, ochaussavoine wrote:
Hi,
I have a table 'tmvt' with a field 'created' in the row, and would like to
compute the difference between successive rows. The solution I found is:
I think you can do it with
What about if there is more than one column you want the difference for (...
coincidentally I am writing a article on this topic right now! ...), say a
table which is used to record a metered quantity at not-quite regular
intervals:
CREATE TABLE electricity
(
current_reading_date date,
Hi all,
trying to run pgwatch1.0 on Ubuntu 12.04 through a Bitnami LAPPstack.
# select version();
PostgreSQL 9.1.1 on i686-pc-linux-gnu, compiled by gcc (GCC) 3.2.2
20030222 (Red Hat Linux 3.2.2-5), 32-bit
Pgwatch installation finishes OK but the webpages of pgwatch display nothing.
Overview:
I assume the EntrerpriseDB certification seminars are an obvious quick
answer:
http://www.enterprisedb.com/products-services-training/training/dba-training
But TBH, I find the PostgreSQL manual to be an excelent guide if you
don't mind reading. It is extremely well written (kudos to whoever is
at 3:41 PM, Bruce Momjian br...@momjian.us wrote:
On Tue, Oct 16, 2012 at 02:34:37PM -0400, Bruce Momjian wrote:
On Tue, Oct 16, 2012 at 02:53:14PM -0300, Thalis Kalfigkopoulos wrote:
I assume the EntrerpriseDB certification seminars are an obvious quick
answer:
http://www.enterprisedb.com
Hi all,
I want to get the databases that correspond to a certain tablespace
through a call to pg_tablespace_databases(tablespace_oid)
Which would be the OID alias type for tablespace_oid?
I've tried:
# select pg_tablespace_databases('pg_default'::XXX);
with XXΧ as any of the OID aliases
Hi all.
I see in the docs the following:
SELECT current_date + s.a AS dates FROM generate_series(0,14,7) AS s(a);
Trying it as:
SELECT current_date + a AS dates FROM generate_series(0,14,7) AS a;
yields exactly the same result.
Does the finer granularity/expressiveness offer some extra
Hi all.
I'd like to tap into the list's experience regarding the job of a DBA
in general and Pg DBA in particular.
I see that most of the DBA job posts ask for Sr or Ssr which is
understandable given that databases are among a company’s most
valuable assets, but it is also an obvious catch-22.
On Sat, Sep 1, 2012 at 6:19 AM, David Johnston pol...@yahoo.com wrote:
On Aug 31, 2012, at 22:49, Tom Lane t...@sss.pgh.pa.us wrote:
David Johnston pol...@yahoo.com writes:
On Aug 31, 2012, at 21:52, Tom Lane t...@sss.pgh.pa.us wrote:
David Johnston pol...@yahoo.com writes:
That said you
Hello all,
I have a query that presents a sum() where in some records it's NULL
because all members of the group are NULL.
I decided I wanted to see a pretty 0 instead of NULL since it fits the
logic of the app.
This didn't work as expected (the NULL's persisted):
...CASE sum(foo) WHEN NULL THEN
Hi Michael.
NULL is not any specific value. Thus Pg correctly doesnot tell you that it
is 'Y'. It is NULL means that we dont know the value. Thus it may be 'Y'
as much as it may not be 'Y'. The comparison is not applicable in the case
of NULL and that's why there are the IS NULL and IS NOT NULL
Sorry for the lack of a more appropriate title.
The summary of my problem is: i run a query and I get some results; then I
create a view using this query, and I run the same query on the view, and
get different results. Details follow.
On the original table the analytical data is as follows:
#
your suggestion of adding an ORDER BY insertedon clause
also seems to work. It makes the first_value(insertedon) behave as
min(insertedon).
thanks again,
Thalis K.
On Mon, Aug 20, 2012 at 12:16 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Thalis Kalfigkopoulos tkalf...@gmail.com writes:
# SELECT id
24 matches
Mail list logo
