Hi,
I am trying to do a custom build (and generate binary and source RPM)
package for PostgreSQL.
I know community already has a RPM package, but I am trying to do a custom
build.
I am using attached SPEC file. But I am not able to get binary rpm.
rpmbuild always gives me source rpm only. Is the
Sameer Kumar wrote:
> I am trying to do a custom build (and generate binary and source RPM) package
> for PostgreSQL.
>
> I know community already has a RPM package, but I am trying to do a custom
> build.
>
> I am using attached SPEC file. But I am not able to get binary rpm. rpmbuild
> alway
Hi,
On Fri, 2013-12-06 at 10:30 +, Albe Laurenz wrote:
> Start looking here:
> http://yum.postgresql.org/srpms/9.3/redhat/rhel-6-x86_64/repoview/postgresql93.html
>
> The source RPMs contain the spec file.
Also, http://svn.pgrpms.org/browser/rpm/redhat/9.3/postgresql/ is the
SVN repo for 9.
That
On Fri, Dec 6, 2013 at 7:08 PM, Sameer Kumar wrote:
> Hi,
>
> I am trying to do a custom build (and generate binary and source RPM)
> package for PostgreSQL.
>
> I know community already has a RPM package, but I am trying to do a custom
> build.
>
> I am using attached SPEC file. But I am n
On Fri, Dec 6, 2013 at 6:30 PM, Albe Laurenz wrote:
> Sameer Kumar wrote:
> > I am trying to do a custom build (and generate binary and source RPM)
> package for PostgreSQL.
> >
> > I know community already has a RPM package, but I am trying to do a
> custom build.
> >
> > I am using attached SPEC
Thanks everyone for helping.
If I were you, I'd simply take the community spec and modify it for my
> needs, it is already really complete and contains automatic management of
> for example translation files, smth that is always a pain to maintain
> manually.
I agree and that is why I asked for
When you click on a table in the "Object browser" you'll see in the "SQL
pane" the sql that is needed to create that table.
Which function can I call to get that SQL?
Best,
Peter
There is no ready available function to generate the reverse engineered
query.
pgAdmin III generates it from the metadata (table information) available.
On Fri, Dec 6, 2013 at 4:17 PM, Peter Kroon wrote:
> When you click on a table in the "Object browser" you'll see in the "SQL
> pane" the sql
Readers,
Admittedly, a biased place to ask (!), but for a new database project,
how best to evaluate whether postgresql or xquery should be used.
As a novice of postgresql and xml, am not sure what is most
appropriate for a new database that will be tested initially on a
local computer, then tran
use pg_dump -s can get the DDL SQL.
jov
在 2013-12-6 下午6:50，"Peter Kroon" 写道：
> When you click on a table in the "Object browser" you'll see in the "SQL
> pane" the sql that is needed to create that table.
>
> Which function can I call to get that SQL?
>
> Best,
> Peter
>
2013/12/6 Peter Kroon :
> When you click on a table in the "Object browser" you'll see in the "SQL
> pane" the sql that is needed to create that table.
>
> Which function can I call to get that SQL?
You can use the pg_dump command line function for this:
pg_dump -s -t name_of_table name_of_data
On 06-12-13 11:54, e-letter wrote:
Readers,
Admittedly, a biased place to ask (!), but for a new database project,
how best to evaluate whether postgresql or xquery should be used.
As a novice of postgresql and xml, am not sure what is most
appropriate for a new database that will be tested in
Thanks, but i need a non command line option.
2013/12/6 Ian Lawrence Barwick
> 2013/12/6 Peter Kroon :
> > When you click on a table in the "Object browser" you'll see in the "SQL
> > pane" the sql that is needed to create that table.
> >
> > Which function can I call to get that SQL?
>
> You c
Hi,
thanks for your Answers.
@Rémi Cura
You suggest a kind of Full Text Search. I already had a try with the tsearch2
extension.
The issue is to realize the similarity search. I have to use many OR statements
with a low set of arguments.
That significantly slows the FTS down.
@Kevin Grittner
Is it possible to test an C extension module (.so file) without
installing a SHAREDIR/extension/extension_name.control file?
My test suite already runs initdb and the database as a non-postgres
user, but I don't see a way to override the extension control file location.
--
Florian Weimer / Re
Janek Sendrowski wrote:
> I didn't know that the pg_trgm Module provides KNN search
It does, although my own experience shows that it tends to be more
appropriate for name searches or similar smaller columns than for
big text columns. Using the war_and_peace table from another
thread:
test=# C
Florian Weimer writes:
> Is it possible to test an C extension module (.so file) without
> installing a SHAREDIR/extension/extension_name.control file?
Well, you could just ignore the extension mechanism: do some
manual CREATE FUNCTION commands and test the functionality
through those.
Sorry, I used AND-statements instead of OR-statement in the example.
I notices that gin is much faster than gist, but I don't know why.
The query gets slow, because there are many non-stop words which appear very
often in my sentences, like in 3% of all the sentences.
Do you think it could be wor
there are several reason drive us to build ourselves rpm, the most important is
we want to install it in a directory self definition
and another reason is setting CFLAGS(add -mavx for example, high light at
previous ).
because, without this compile parameter, response time is suffering on dell
m
On 12/6/2013 11:04 AM, 吕晓旭 wrote:
I find something with top : CPU usage of each postgres process is not
so high when low concurrency, the highest one is about 50%.
but when concurrency gradually increased, some postgres process cpu
usage reach 100%, and keep a moment. and at these high concurren
20 matches
Mail list logo
