mperformer wrote:
> I have a question regarding PostgreSQL 9.1 indexing.
>
> I am having a table and want to create a index for a column and I want
to store the data with time
> zone for that column. The questions are:
>
> 1. Can I create a index for a column which store time stamp with time
zone
On 07/12/2012 02:16 PM, Bartosz Dmytrak wrote:
it doesn't metter - conclusion is: table is growing. You are right,
for other purposes it should be better to check total size.
In that case, I'm not sure I understand what you were actually asking in
your initial question.
--
Craig Ringer
I have a table with bibliometric information on published articles.
Fields of interest for full text searches are the 'title' and 'abstract'
fields.
Those fields can contain several languages but most of the entries use
English. A grouped query on the 'language' field reveals that the
following la
On Wed, Jul 11, 2012 at 6:28 PM, martin soethof
wrote:
> Hello
> I have the following situation.
> I used a postgres installer that can choose seperate paths for the normal
> postgres and the data folder.
> I used this because i wanted to share a database on an external hard drive
> between 2 com
On 07/12/2012 12:39 AM, Craig Ringer wrote:
On 07/12/2012 02:16 PM, Bartosz Dmytrak wrote:
it doesn't metter - conclusion is: table is growing. You are right,
for other purposes it should be better to check total size.
In that case, I'm not sure I understand what you were actually asking in
> I'm looking for FOSS PostgreSQL CRUD software, preferably
> Perl-compatible, which will enable me to design input forms which can
> handle input to tables which reference other tables by foreign key.
> Most CRUD applications I have seen so far only deal with direct, form
> field to table field in
Adrian Klaver writes:
> On 07/12/2012 12:39 AM, Craig Ringer wrote:
>> In that case, I'm not sure I understand what you were actually asking in
>> your initial question.
> I understood it to be asking about the conflict between the two
> statements below:
> Maximum Table Size32 TB
> Maximum
On 07/12/2012 06:44 AM, Tom Lane wrote:
Adrian Klaver writes:
On 07/12/2012 12:39 AM, Craig Ringer wrote:
In that case, I'm not sure I understand what you were actually asking in
your initial question.
I understood it to be asking about the conflict between the two
statements below:
Maxi
On Jul 12, 2012, at 9:44, Tom Lane wrote:
>
> We could perhaps replace "unlimited" by the result of dividing the max
> table size by the minimum row size. I'm not sure that would be
> particularly helpful though, since most tables are probably a good deal
> wider than the minimum row size, and
Hi there,
not being an expert for Postgres…. I have a Postgis table with the countries of
the world. Now, I would like to drop it. I got the error message:
ERROR: out of shared memory
HINT: You might need to increase max_locks_per_transaction.
and thought that it would be easier to
Hei Josh, problem solved!
Thanks for your help!
On Wed, Jul 11, 2012 at 4:27 PM, Josh Kupershmidt wrote:
> [Please keep the list CC'd]
>
> On Wed, Jul 11, 2012 at 3:58 AM, Filipe brandão
> wrote:
>
> > Now, i only need to link these processes (trigger completion and running
> the
> > script).
>
postgres user does not exist yet, its a fresh new installation of
windows 7 Home. New HP laptop.
there is only my account (admin) and Guest
i saw on internet someone had similar problem and this was resolved by
removing HP protection tools tha was messing with policies, but i
already removed it be
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
>> This behavior is intentional.
> In that case, the error lies with the Perl libraries that automatically
> prepare and cache queries, but do not include the search_path in the
> cache keys.
You have lost me there. Which Perl libraries are
2012/7/12 David Johnston
>
>
> How about saying: "No Fixed Limit - see Table Size"
>
>
I am sorry for delay. My intention was to start discussion about unlimited
number of rows.
I like this idea: "No Fixed Limit - see Table Size"
Another, maybe only academic, discussion is about maximum number o
I have a table, this table are rarely changed (added or deleted).
My function receive parameters and do a query to the table.
Does postgres re run the query on each function call, or has some kind of
"flag" indicating that table as not been changed and return cached result of
a previous call i
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Anibal David Acosta
Sent: Thursday, July 12, 2012 2:39 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] how much volatile is a function
I have a table, this table are rarely changed (added or de
On Thu, Jul 12, 2012 at 10:38 PM, Anibal David Acosta wrote:
> Does postgres re run the query on each function call, or has some kind of
> “flag” indicating that table as not been changed and return cached result of
> a previous call if the call has same parameters?
It does re-run it on each call
On Thu, Jul 12, 2012 at 10:55 PM, Sergey Konoplev
wrote:
> On Thu, Jul 12, 2012 at 10:38 PM, Anibal David Acosta
> wrote:
>> Does postgres re run the query on each function call, or has some kind of
>> “flag” indicating that table as not been changed and return cached result of
>> a previous cal
On tor, 2012-06-21 at 07:49 +0200, P. Broennimann wrote:
> select query_to_xml('select * from table12', true, true, '') into ...
> The result is OK but there is always an empty line:
>
> http://www.w3.org/2001/XMLSchema-instance";>
> *<-- Empty line here*
> FG897
On Friday, January 7, 2011 4:15:25 PM UTC+6, "Satish Burnwal
(sburnwal)" wrote:
> I have 2 tables containing the data for same items:
>
> STORE1
> -
> Idtypeitems
> -
> 1 FOOD10
> 2 FOOD15
> 3
Hi Laurenz
Many thanks for your reply.
Could you please bit more explain about the following sentence you wrote:
There are no performance problems except the ones that always come with an
index: INSERTs, UPDATEs and DELETEs will be slower and do more disk I/O and
locking.
Many Thanks
--
View t
On 07/13/2012 06:06 AM, codevally wrote:
Hi Laurenz
Many thanks for your reply.
Could you please bit more explain about the following sentence you wrote:
There are no performance problems except the ones that always come with an
index: INSERTs, UPDATEs and DELETEs will be slower and do more di
On 13/07/12 02:59, Greg Sabino Mullane wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
This behavior is intentional.
In that case, the error lies with the Perl libraries that automatically
prepare and cache queries, but do not include the search_path in the
cache keys.
You have
On Thu, Jul 12, 2012 at 8:23 PM, Stefan Schwarzer wrote:
> Hi there,
>
> not being an expert for Postgres…. I have a Postgis table with the
> countries of the world. Now, I would like to drop it. I got the error
> message:
>
> ERROR: out of shared memory
> HINT: You might need to incr
Hi all
I'm using Pg 9.1, working on enhancing my audit logging so it can record
not only the old and new values of a record when it changes, but what
exactly changed.
It's easy to produce hstore values for the old and new records, and I've
been happily logging those. I was about to start te
On Fri, Jul 13, 2012 at 9:51 AM, Craig Ringer
wrote:
> ... but it feels like there must be a smarter way.
Well, may be kind of (h1 - h2), (h2 - h1) and derivatives will make sense?
--
Sergey Konoplev
a database architect, software developer at PostgreSQL-Consulting.com
http://www.postgresql-c
Could you see anything wrong in the installation log?
(%TEMP%\install-postgresql.log)
On Thu, Jul 12, 2012 at 11:04 AM, KOTa wrote:
> postgres user does not exist yet, its a fresh new installation of
> windows 7 Home. New HP laptop.
> there is only my account (admin) and Guest
>
> i saw on inter
27 matches
Mail list logo
