hi,
when i create an unique-constraint on a varchar field, how exactly
does postgresql compare the texts? i'm asking because in UNICODE there
are a lot of complexities about this..
or in other words, when are two varchars equal in postgres? when their
bytes are? or some algorithm is applied?
On 15/01/2014 10:10, Gábor Farkas wrote:
hi,
when i create an unique-constraint on a varchar field, how exactly
does postgresql compare the texts? i'm asking because in UNICODE there
are a lot of complexities about this..
or in other words, when are two varchars equal in postgres? when
The error you are seeing is triggered because this relation file
exceeds MAX_TAR_MEMBER_FILELEN or 8GB for a single tar member, which
is as well the norm for tar.
I thought PostgreSQL would break the file if it grows beyond 1GB (1GB is
segment size which one can modify while compiling). Am I
On Jan 15, 2014 12:07 PM, Sameer Kumar sameer.ku...@ashnik.com wrote:
The error you are seeing is triggered because this relation file
exceeds MAX_TAR_MEMBER_FILELEN or 8GB for a single tar member, which
is as well the norm for tar.
I thought PostgreSQL would break the file if it grows
On Wed, Jan 15, 2014 at 7:39 PM, Ivan Voras ivo...@freebsd.org wrote:
On 15/01/2014 10:10, Gábor Farkas wrote:
hi,
when i create an unique-constraint on a varchar field, how exactly
does postgresql compare the texts? i'm asking because in UNICODE there
are a lot of complexities about this..
On 15/01/2014 12:36, Amit Langote wrote:
On Wed, Jan 15, 2014 at 7:39 PM, Ivan Voras ivo...@freebsd.org wrote:
On 15/01/2014 10:10, Gábor Farkas wrote:
hi,
when i create an unique-constraint on a varchar field, how exactly
does postgresql compare the texts? i'm asking because in UNICODE
On Wed, Jan 15, 2014 at 9:02 PM, Ivan Voras ivo...@freebsd.org wrote:
On 15/01/2014 12:36, Amit Langote wrote:
On Wed, Jan 15, 2014 at 7:39 PM, Ivan Voras ivo...@freebsd.org wrote:
On 15/01/2014 10:10, Gábor Farkas wrote:
hi,
when i create an unique-constraint on a varchar field, how exactly
On 15/01/2014 13:29, Amit Langote wrote:
On Wed, Jan 15, 2014 at 9:02 PM, Ivan Voras ivo...@freebsd.org wrote:
On 15/01/2014 12:36, Amit Langote wrote:
* In some locales strcoll() can claim that
nonidentical strings are
* equal. Believing that would be bad
Hi, I've installed SkyTools3 on Ubuntu 12.04 Server, and got stuck when
trying to execute pgqadm.py (Step 5:
http://manojadinesh.blogspot.com.ar/2012/11/skytools-londiste-replication.html).
Does anyone know if pgqadm.py was replaced in SkyTools3?. Any up-to-date
tutorial?.
Regards,
--
Leonardo
because that is also one of the important counter to know postgresql server
status. thats why i am asking @sameer
Thanks Regards,
A.Mohamed Bilal
On Sat, Jan 11, 2014 at 7:15 PM, Sameer Kumar [via PostgreSQL]
ml-node+s1045698n5786458...@n5.nabble.com wrote:
On Fri, Jan 10, 2014 at 2:57 PM,
@sameer, can you tell me the full query for that? because in pg_stat_all_tables
contains many fields. i dont know whats the correct one to get the result.
Thanks Regards,
A.Mohamed Bilal
On Wed, Jan 15, 2014 at 10:57 AM, Mohamed Bilal ambilal...@gmail.comwrote:
because that is also one of
http://postgresql.1045698.n5.nabble.com/file/n5787214/ScreenShot.jpg hi
Any help appreciated (newbie to pgsql)
I have a function f_Sanjeev and create a view
create view v_sanjeev as select * from f_sanjeev()
the view has and OBJID of 5134719
oid reltype relname relnamespacereltype
On Wed, Jan 15, 2014 at 7:36 AM, ambilalmca ambilal...@gmail.com wrote:
can you tell me the full query for that? because in pg_stat_all_tables
contains many fields. i dont know whats the correct one to get the result.
*Number of cached blocks read,
Number of cached index blocks read,
Hi all,
I'm studying pg_statistic table and I find that column staop is related to
pg_operator, and different data types relate to different staop, but I
don't know where pgsql stores the mapping between pg_type and pg_operator,
does anyone have any idea about it? thanks!
On Wed, Jan 15, 2014 at 8:37 PM, saggarwal sanj.aggar...@gmail.com wrote:
http://postgresql.1045698.n5.nabble.com/file/n5787214/ScreenShot.jpg hi
Any help appreciated (newbie to pgsql)
I have a function f_Sanjeev and create a view
create view v_sanjeev as select * from f_sanjeev()
the view
On Wed, Jan 15, 2014 at 8:05 PM, Sameer Kumar sameer.ku...@ashnik.comwrote:
The error you are seeing is triggered because this relation file
exceeds MAX_TAR_MEMBER_FILELEN or 8GB for a single tar member, which
is as well the norm for tar.
I thought PostgreSQL would break the file if it
Ivan Voras ivo...@freebsd.org writes:
On 15/01/2014 12:36, Amit Langote wrote:
Just to add to this, whenever strcoll() (a locale aware comparator)
says two strings are equal, postgres re-compares them using strcmp().
That seems odd and inefficient. Why would it be necessary? I would think
On Wed, Jan 15, 2014 at 11:08 PM, Felix.徐 ygnhz...@gmail.com wrote:
Hi all,
I'm studying pg_statistic table and I find that column staop is related to
pg_operator, and different data types relate to different staop, but I don't
know where pgsql stores the mapping between pg_type and
Deal all,
In my project, there is a requirement to implement proximity search
feature. We are running a mobile app, for which proximity search is
require. Can any one guide me how i can achieve this using postgis, or is
there any other way i can achieve this.
We are using postgresql 9.2.
Thanks
Hi Amit
I understand, I've read the source code of analyze.c and implemented a java
version.
Stakind1(most common values) indicates = operator and stakind2(histogram)
indicates operator by default,
I'm wondering where I can find the corresponding operatorID of eq/lt for a
specific data type.
For
On Wed, Jan 15, 2014 at 4:10 AM, Gábor Farkas gabor.far...@gmail.comwrote:
or in other words, when are two varchars equal in postgres? when their
bytes are? or some algorithm is applied?
On this topic, when I write my strings to the DB and search from the DB,
should I canonicalize them first
On Wed, Jan 15, 2014 at 10:48 AM, Michael Paquier
michael.paqu...@gmail.com wrote:
On Wed, Jan 15, 2014 at 1:26 AM, Ming Li mli89...@gmail.com wrote:
I'm a little bit confused by the meaning of xmax.
The documentation at
http://www.postgresql.org/docs/current/static/ddl-system-columns.html
=?GB2312?B?RmVsaXgu0Ow=?= ygnhz...@gmail.com writes:
I'm wondering where I can find the corresponding operatorID of eq/lt for a
specific data type.
The ones ANALYZE uses are the members of the default btree opclass for
the datatype. If there isn't one, it doesn't build a histogram.
And
check knn search, http://www.sai.msu.su/~megera/postgres/talks/pgcon-2010-1.pdf
On Wed, Jan 15, 2014 at 8:04 PM, itishree sukla
itishree.su...@gmail.com wrote:
Deal all,
In my project, there is a requirement to implement proximity search feature.
We are running a mobile app, for which
Hey,
I'm trying to use an array of text as input in a C function in a custom
extension.
the prototype of the sql function is :
CREATE OR REPLACE FUNCTION pc_subset( dimensions TEXT[])
it is called like :
pc_subset( ARRAY['X'::text,'Y'::text])
and the C function trying to read the text array
thanks, exactly what I needed
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/pg-depend-OBJID-not-found-tp5787214p5787260.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list
On 01/13/2014 01:38 PM, Francisco Olarte wrote:
Hi:
On Mon, Jan 13, 2014 at 5:26 PM, Tirthankar Barari tbar...@verizon.com wrote:
On 01/10/2014 07:06 AM, Francisco Olarte wrote:
Not related to your vacuum problem, but if your pattern is something
like deleting everything inserted 15 days ago
Thanks all
alan
On Jan 15, 2014, at 6:30 AM, Michael Paquier michael.paqu...@gmail.com wrote:
On Wed, Jan 15, 2014 at 8:05 PM, Sameer Kumar sameer.ku...@ashnik.com wrote:
The error you are seeing is triggered because this relation file
exceeds MAX_TAR_MEMBER_FILELEN or 8GB for a single
Hi,
I am asking because ...
I have a table with
relpages | 19164
reltuples | 194775
pg_relation_size / 8192 yields the same number as relpages. So, there is
no need to scale reltuples. Relcardinality is therefore 194775.
Statistics target is the default, 100. So, I assume each of the 100
Our app makes extensive use of temp tables, and this causes a
significant amount of bloat that can often only be cleared with a manual
vacuum process. We're looking for a better way that doesn't involve
locking, we found pg_repack and pg_reorg and were wondering if anybody
here could weigh in
Lists li...@benjamindsmith.com writes:
Our app makes extensive use of temp tables, and this causes a
significant amount of bloat that can often only be cleared with a manual
vacuum process. We're looking for a better way that doesn't involve
locking, we found pg_repack and pg_reorg and
On Wed, Jan 15, 2014 at 04:09:28PM -0800, Lists wrote:
Our app makes extensive use of temp tables, and this causes a
significant amount of bloat that can often only be cleared with a
Note what Tom Lane said, but why do you have bloat that can only be
cleared by vacuum? Why not drop them or
On 1/15/2014 4:09 PM, Lists wrote:
Our app makes extensive use of temp tables, and this causes a
significant amount of bloat that can often only be cleared with a
manual vacuum process.
whats the persistence of these temporary tables?by design, they are
meant for relatively short
On 01/15/2014 04:24 PM, Tom Lane wrote:
Lists li...@benjamindsmith.com writes:
Our app makes extensive use of temp tables, and this causes a
significant amount of bloat that can often only be cleared with a manual
vacuum process. We're looking for a better way that doesn't involve
locking, we
34 matches
Mail list logo